APPS.OKE_DELIVERABLE_ACTIONS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 153: FROM mtl_system_items

149: c3info c3%rowtype;
150:
151: CURSOR c4 ( P_Item_ID NUMBER, P_Org_ID NUMBER ) IS
152: SELECT primary_uom_code
153: FROM mtl_system_items
154: WHERE inventory_item_id = p_item_id
155: AND organization_id = p_org_id;
156:
157: BEGIN

Line 296: , mtl_system_items d

292: , c.expected_date) workdate
293: , d.primary_uom_code
294: FROM oke_deliverables_b b
295: , oke_deliverable_actions c
296: , mtl_system_items d
297: WHERE c.action_id = p_action_id
298: AND b.deliverable_id = c.deliverable_id
299: AND d.inventory_item_id = b.item_id
300: AND d.organization_id = c.ship_from_org_id;

Line 516: FROM mtl_system_items

512: c3info c3%rowtype;
513:
514: CURSOR c4 ( p_org_id number,P_item_ID NUMBER ) IS
515: SELECT MTL_Transactions_Enabled_Flag
516: FROM mtl_system_items
517: where organization_id = p_org_id
518: and inventory_item_id = p_item_id;
519:
520: BEGIN

Line 905: FROM mtl_system_items

901: FUNCTION Charge_Account ( P_Item_ID NUMBER, P_Org_ID NUMBER) RETURN NUMBER IS
902:
903: CURSOR Item_C IS
904: SELECT Expense_Account
905: FROM mtl_system_items
906: WHERE Inventory_Item_ID = P_Item_ID
907: AND Organization_ID = P_Org_ID;
908:
909: CURSOR Org_C IS