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 681: FROM mtl_system_items

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

Line 2434: FROM mtl_system_items

2430: FUNCTION Charge_Account ( P_Item_ID NUMBER, P_Org_ID NUMBER) RETURN NUMBER IS
2431:
2432: CURSOR Item_C IS
2433: SELECT Expense_Account
2434: FROM mtl_system_items
2435: WHERE Inventory_Item_ID = P_Item_ID
2436: AND Organization_ID = P_Org_ID;
2437:
2438: CURSOR Org_C IS