DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on BOM_DELETE_ENTITIES

Line 3150: (select 1 from bom_delete_entities where delete_status_type <> 4 and inventory_item_id = item.revised_item_id and organization_id = item.organization_id);

3146: l_no_del_groups number;
3147: begin
3148: IF( item.transfer_or_copy_item =1 OR item.transfer_or_copy_bill = 1 OR item.transfer_or_copy_routing = 1) THEN
3149: select count(*) into l_no_del_groups from dual where exists
3150: (select 1 from bom_delete_entities where delete_status_type <> 4 and inventory_item_id = item.revised_item_id and organization_id = item.organization_id);
3151: if (l_no_del_groups > 0) then
3152: msg_qty := msg_qty + 1;
3153: message_names(msg_qty) := 'ENG_TRANSFER_PENDING_DG';
3154: token1(msg_qty) := 'ITEM_NAME';