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

728:
729: /*added for bug13038760*/
730: CURSOR c_allow_desc_upd ( p_org_id number,P_item_ID NUMBER ) IS
731: SELECT allow_item_desc_update_flag
732: FROM mtl_system_items
733: where organization_id = p_org_id
734: and inventory_item_id = p_item_id;
735:
736: l_allow_item_desc_upd_flag VARCHAR2(1);

Line 920: FROM mtl_system_items

916: FUNCTION Charge_Account ( P_Item_ID NUMBER, P_Org_ID NUMBER) RETURN NUMBER IS
917:
918: CURSOR Item_C IS
919: SELECT Expense_Account
920: FROM mtl_system_items
921: WHERE Inventory_Item_ID = P_Item_ID
922: AND Organization_ID = P_Org_ID;
923:
924: CURSOR Org_C IS