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 750: /* Update the delete_group_name from bom_interface_delete_groups */

746: WHERE mil2.INVENTORY_LOCATION_ID = BICI.supply_locator_id
747: and mil2.organization_id = BICI.organization_id);
748:
749: stmt_num := 8.5;
750: /* Update the delete_group_name from bom_interface_delete_groups */
751: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
752: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
753: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
754: FROM bom_interface_delete_groups

Line 754: FROM bom_interface_delete_groups

750: /* Update the delete_group_name from bom_interface_delete_groups */
751: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
752: SET (DELETE_GROUP_NAME, DG_DESCRIPTION)
753: = (SELECT DELETE_GROUP_NAME, DESCRIPTION
754: FROM bom_interface_delete_groups
755: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'
756: And rownum = 1)
757: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
758: AND upper(transaction_type) in (G_Delete)

Line 767: FROM bom_interface_delete_groups

763: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
764: OR ( p_batch_id = BICI.batch_id )
765: )
766: AND exists (SELECT 'x'
767: FROM bom_interface_delete_groups
768: Where upper(entity_name) = 'BOM_INVENTORY_COMPS_INTERFACE'
769: );
770:
771: