APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 5080: FROM bom_inventory_components bic

5076: AND batch_id = p_batch_id
5077: AND process_flag = G_CM_TO_BE_PROCESSED
5078: AND transaction_type in ('DELETE', 'UPDATE')
5079: AND not exists (SELECT 1
5080: FROM bom_inventory_components bic
5081: WHERE
5082: bic.component_sequence_id = bici.component_sequence_id
5083: AND bic.revised_item_sequence_id = p_revised_item_sequence_id);
5084:

Line 5094: FROM bom_inventory_components bic

5090: UPDATE bom_inventory_comps_interface bici
5091: SET
5092: acd_type = decode(transaction_type, 'DELETE', G_BOM_DISABLE_ACD_TYPE,
5093: (SELECT bic.acd_type
5094: FROM bom_inventory_components bic
5095: WHERE
5096: bic.component_sequence_id = bici.component_sequence_id
5097: AND bic.revised_item_sequence_id = p_revised_item_sequence_id)),
5098: change_transaction_type = decode(transaction_type, 'DELETE', 'DELETE', 'UPDATE'),

Line 5138: FROM bom_inventory_components bic

5134: AND batch_id = p_batch_id
5135: AND process_flag = G_CM_TO_BE_PROCESSED
5136: AND transaction_type in ('DELETE', 'UPDATE')
5137: AND exists (SELECT 1
5138: FROM bom_inventory_components bic
5139: WHERE
5140: bic.component_sequence_id = bici.component_sequence_id
5141: AND bic.revised_item_sequence_id = p_revised_item_sequence_id);
5142:

Line 5153: bom_inventory_components bic

5149: UPDATE bom_ref_desgs_interface brdi
5150: SET
5151: acd_type = (SELECT brd.acd_type
5152: FROM bom_reference_designators brd,
5153: bom_inventory_components bic
5154: WHERE brd.component_sequence_id = bic.component_sequence_id
5155: AND brd.component_reference_designator = brdi.component_reference_designator
5156: AND bic.revised_item_sequence_id = p_revised_item_sequence_id
5157: AND bic.component_item_id = brdi.component_item_id),

Line 5172: bom_inventory_components bic

5168: AND brdi.process_flag = G_CM_TO_BE_PROCESSED
5169: AND brdi.transaction_type in ('DELETE', 'UPDATE')
5170: AND exists (SELECT 1
5171: FROM bom_reference_designators brd,
5172: bom_inventory_components bic
5173: WHERE brd.component_sequence_id = bic.component_sequence_id
5174: AND brd.component_reference_designator = brdi.component_reference_designator
5175: AND bic.revised_item_sequence_id = p_revised_item_sequence_id
5176: AND bic.component_item_id = brdi.component_item_id);

Line 5186: bom_inventory_components bic

5182: UPDATE bom_sub_comps_interface bsci
5183: SET
5184: acd_type = (SELECT bsc.acd_type
5185: FROM bom_substitute_components bsc,
5186: bom_inventory_components bic
5187: WHERE bsc.component_sequence_id = bic.component_sequence_id
5188: AND bsc.substitute_component_id = bsci.substitute_component_id
5189: AND bic.revised_item_sequence_id = p_revised_item_sequence_id
5190: AND bic.component_item_id = bsci.component_item_id),

Line 5205: bom_inventory_components bic

5201: AND bsci.process_flag = G_CM_TO_BE_PROCESSED
5202: AND bsci.transaction_type in ('DELETE', 'UPDATE')
5203: AND exists (SELECT 1
5204: FROM bom_substitute_components bsc,
5205: bom_inventory_components bic
5206: WHERE bsc.component_sequence_id = bic.component_sequence_id
5207: AND bsc.substitute_component_id = bsci.substitute_component_id
5208: AND bic.revised_item_sequence_id = p_revised_item_sequence_id
5209: AND bic.component_item_id = bsci.component_item_id);