Note:- The following Query can get multiple records, since one Item can assoiciate to many Inventory Organizations.In the following Query, I have commented the organization_id condition and given the rownum = 1 condition.Catalog is the Flexfield. The values in these also depends upon the Set-up part of the Catalog Flexfield.MTL_DESCR_ELEMENT_VALUES stores the descriptive element values for […]
The following Query will On-hand Quatity of particular item in the whole Organization select sum(primary_transaction_quantity) from mtl_onhand_quantities_detail where inventory_item_id = ‘Your Inventory Organization ID’; Example:- Note:- 123456 is the item ID of the particular item. This can be found in the base table of the item (MTL_SYSTEM_ITEMS_B). SEGMENT1 column of this table would have Item […]
When we Purchase some material/Goods/Items from Vendor/Supplier, after receiving the material. Vendor would send the INVOICE (In other words we receive BILL for the Items you have received). And payment will be done automatically. If there is some Discrepancy in the Items received and in the BILL/INVOICE you received, for them to hold the payment we normally […]
When we Purchase some material/Goods/Items from Vendor/Supplier, after receiving the material. Vendor would send the INVOICE (In other words we receive BILL for the Items you have received). And payment will be done automatically. If there is some Discrepancy in the Items received and in the BILL/INVOICE you received, for them to hold the payment we normally […]
Q) What is Planning Budget? A) The plan for the future expenses is planning budget. It is a paper work. There is no funds requirement. It does not require journals. There are no restrictions for estimating of funds. It is a budget through which you cannot excercise budgetary control . But you can compare your […]
Recent Comments