APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_INTERFACE_DELETE_GROUPS

Line 269: /* Update the delete_group_name from bom_interface_delete_groups */

265: FROM MTL_SYSTEM_ITEMS mvl2
266: WHERE mvl2.inventory_item_id = BBMI.common_assembly_item_id
267: AND mvl2.organization_id = BBMI.common_organization_id);
268:
269: /* Update the delete_group_name from bom_interface_delete_groups */
270: stmt_num := 9.5;
271: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
272: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
273: = (SELECT DELETE_GROUP_NAME, DESCRIPTION

Line 274: FROM bom_interface_delete_groups

270: stmt_num := 9.5;
271: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBMI
272: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
273: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
274: FROM bom_interface_delete_groups
275: Where upper(entity_name) = 'BOM_BILL_OF_MTLS_INTERFACE'
276: And rownum = 1)
277: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
278: AND upper(transaction_type) in (G_Delete)

Line 287: FROM bom_interface_delete_groups

283: ( (p_batch_id IS NULL) AND (BBMI.batch_id IS NULL) )
284: OR ( p_batch_id = BBMI.batch_id )
285: )
286: AND exists (SELECT 'x'
287: FROM bom_interface_delete_groups
288: Where upper(entity_name) = 'BOM_BILL_OF_MTLS_INTERFACE'
289: );
290:
291: stmt_num := 9.6;

Line 760: /* Update the delete_group_name from bom_interface_delete_groups */

756: WHERE mil2.INVENTORY_LOCATION_ID = BICI.supply_locator_id
757: and mil2.organization_id = BICI.organization_id);
758:
759: stmt_num := 8.5;
760: /* Update the delete_group_name from bom_interface_delete_groups */
761: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
762: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
763: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
764: FROM bom_interface_delete_groups

Line 764: FROM bom_interface_delete_groups

760: /* Update the delete_group_name from bom_interface_delete_groups */
761: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
762: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
763: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
764: FROM bom_interface_delete_groups
765: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'
766: And rownum = 1)
767: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
768: AND change_notice is null --added for bug 9673701

Line 778: FROM bom_interface_delete_groups

774: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
775: OR ( p_batch_id = BICI.batch_id )
776: )
777: AND exists (SELECT 'x'
778: FROM bom_interface_delete_groups
779: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'
780: );
781:
782: