APPS.BOM_INV_COMPS2_PKG dependencies on BOM_CONFIG_EXPLOSIONS

Line 527: BOM_CONFIG_EXPLOSIONS bce

523: decode(bce.bom_item_type, 4, msi.wip_supply_locator_id,null),
524: bce.PICK_COMPONENTS,
525: bce.BOM_ITEM_TYPE
526: FROM MTL_SYSTEM_ITEMS msi,
527: BOM_CONFIG_EXPLOSIONS bce
528: WHERE bce.group_id = X_group_id
529: AND bce.component_item_id = msi.inventory_item_id
530: AND bce.organization_id = msi.organization_id;
531:

Line 533: Delete from BOM_CONFIG_EXPLOSIONS

529: AND bce.component_item_id = msi.inventory_item_id
530: AND bce.organization_id = msi.organization_id;
531:
532: -- Clean up table after a successful insert
533: Delete from BOM_CONFIG_EXPLOSIONS
534: where group_id = X_group_id;
535:
536: -- Returns success code
537: Return 0;