APPS.OKE_DTS_INTEGRATION_PKG dependencies on MTL_SYSTEM_ITEMS

Line 413: FROM mtl_system_items

409: l_mps_transaction_id NUMBER;
410:
411: CURSOR Uom_C ( P_Item_ID NUMBER , P_Org_ID NUMBER ) IS
412: SELECT Primary_Uom_Code
413: FROM mtl_system_items
414: WHERE inventory_item_id = P_Item_ID
415: AND organization_id = P_Org_ID;
416:
417: CURSOR sdates_c IS

Line 683: FROM mtl_system_items

679: AND H.ID = B.K_HEADER_ID;
680:
681: CURSOR Item_C ( P_ID NUMBER ) IS
682: SELECT Decode(MTL_Transactions_Enabled_Flag, 'Y', 'Y', 'N')
683: FROM mtl_system_items
684: WHERE Inventory_Item_ID = P_ID;
685:
686: CURSOR OU_C ( P_Organization_ID NUMBER ) IS
687: SELECT OPERATING_UNIT

Line 2478: FROM mtl_system_items

2474: FUNCTION Charge_Account ( P_Item_ID NUMBER, P_Org_ID NUMBER) RETURN NUMBER IS
2475:
2476: CURSOR Item_C IS
2477: SELECT Expense_Account
2478: FROM mtl_system_items
2479: WHERE Inventory_Item_ID = P_Item_ID
2480: AND Organization_ID = P_Org_ID;
2481:
2482: CURSOR Org_C IS