DBA Data[Home] [Help]

APPS.BOM_REVISION_API dependencies on MTL_SYSTEM_ITEMS

Line 111: SET transaction_id = mtl_system_items_interface_s.nextval,

107: */
108: stmt_num := 2;
109: LOOP
110: UPDATE mtl_item_revisions_interface
111: SET transaction_id = mtl_system_items_interface_s.nextval,
112: transaction_type = upper(transaction_type)
113: WHERE transaction_id is null
114: and process_flag = 1
115: and upper(transaction_type) in (G_Insert, G_Update)

Line 762: from mtl_system_items

758: stmt_num := 7;
759: BEGIN
760: select 1
761: into dummy
762: from mtl_system_items
763: where organization_id = c0rec.OI
764: and inventory_item_id = c0rec.AII;
765: EXCEPTION
766: WHEN No_Data_Found THEN