DBA Data[Home] [Help]

APPS.BOM_COMPONENT_API dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 156: SET transaction_id = mtl_system_items_interface_s.nextval,

152: */
153: stmt_num := 1;
154: LOOP
155: UPDATE bom_inventory_comps_interface
156: SET transaction_id = mtl_system_items_interface_s.nextval,
157: component_sequence_id = bom_inventory_components_s.nextval,
158: transaction_type = upper(transaction_type)
159: WHERE transaction_id is null
160: AND process_flag = 1

Line 177: SET transaction_id = mtl_system_items_interface_s.nextval,

173: */
174: stmt_num := 1;
175: LOOP
176: UPDATE bom_inventory_comps_interface
177: SET transaction_id = mtl_system_items_interface_s.nextval,
178: transaction_type = upper(transaction_type)
179: WHERE transaction_id is null
180: AND process_flag = 1
181: AND upper(transaction_type) in (G_UPDATE, G_DELETE)