DBA Data[Home] [Help]

APPS.GME_MOVE_ORDERS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 161: FROM mtl_system_items_b

157:
158: CURSOR cur_item_mst (v_org_id NUMBER, v_inventory_item_id NUMBER)
159: IS
160: SELECT mtl_transactions_enabled_flag, secondary_uom_code, segment1
161: FROM mtl_system_items_b
162: WHERE organization_id = v_org_id
163: AND inventory_item_id = v_inventory_item_id;
164:
165: -- 9268209

Line 853: FROM mtl_system_items_b

849: -- Bug 9028327 - Add cursor and local vars.
850: CURSOR cur_item_mst (v_org_id NUMBER, v_inventory_item_id NUMBER)
851: IS
852: SELECT primary_uom_code, secondary_uom_code, tracking_quantity_ind
853: FROM mtl_system_items_b
854: WHERE organization_id = v_org_id
855: AND inventory_item_id = v_inventory_item_id;
856:
857: l_prim_uom_code VARCHAR2 (4);