APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 4974: FROM bom_inventory_components bic

4970: AND batch_id = p_batch_id
4971: AND process_flag = G_CM_TO_BE_PROCESSED
4972: AND transaction_type in ('DELETE', 'UPDATE')
4973: AND not exists (SELECT 1
4974: FROM bom_inventory_components bic
4975: WHERE
4976: bic.component_sequence_id = bici.component_sequence_id
4977: AND bic.revised_item_sequence_id = p_revised_item_sequence_id);
4978:

Line 4988: FROM bom_inventory_components bic

4984: UPDATE bom_inventory_comps_interface bici
4985: SET
4986: acd_type = decode(transaction_type, 'DELETE', G_BOM_DISABLE_ACD_TYPE,
4987: (SELECT bic.acd_type
4988: FROM bom_inventory_components bic
4989: WHERE
4990: bic.component_sequence_id = bici.component_sequence_id
4991: AND bic.revised_item_sequence_id = p_revised_item_sequence_id)),
4992: change_transaction_type = decode(transaction_type, 'DELETE', 'DELETE', 'UPDATE'),

Line 5032: FROM bom_inventory_components bic

5028: AND batch_id = p_batch_id
5029: AND process_flag = G_CM_TO_BE_PROCESSED
5030: AND transaction_type in ('DELETE', 'UPDATE')
5031: AND exists (SELECT 1
5032: FROM bom_inventory_components bic
5033: WHERE
5034: bic.component_sequence_id = bici.component_sequence_id
5035: AND bic.revised_item_sequence_id = p_revised_item_sequence_id);
5036:

Line 5047: bom_inventory_components bic

5043: UPDATE bom_ref_desgs_interface brdi
5044: SET
5045: acd_type = (SELECT brd.acd_type
5046: FROM bom_reference_designators brd,
5047: bom_inventory_components bic
5048: WHERE brd.component_sequence_id = bic.component_sequence_id
5049: AND brd.component_reference_designator = brdi.component_reference_designator
5050: AND bic.revised_item_sequence_id = p_revised_item_sequence_id
5051: AND bic.component_item_id = brdi.component_item_id),

Line 5066: bom_inventory_components bic

5062: AND brdi.process_flag = G_CM_TO_BE_PROCESSED
5063: AND brdi.transaction_type in ('DELETE', 'UPDATE')
5064: AND exists (SELECT 1
5065: FROM bom_reference_designators brd,
5066: bom_inventory_components bic
5067: WHERE brd.component_sequence_id = bic.component_sequence_id
5068: AND brd.component_reference_designator = brdi.component_reference_designator
5069: AND bic.revised_item_sequence_id = p_revised_item_sequence_id
5070: AND bic.component_item_id = brdi.component_item_id);

Line 5080: bom_inventory_components bic

5076: UPDATE bom_sub_comps_interface bsci
5077: SET
5078: acd_type = (SELECT bsc.acd_type
5079: FROM bom_substitute_components bsc,
5080: bom_inventory_components bic
5081: WHERE bsc.component_sequence_id = bic.component_sequence_id
5082: AND bsc.substitute_component_id = bsci.substitute_component_id
5083: AND bic.revised_item_sequence_id = p_revised_item_sequence_id
5084: AND bic.component_item_id = bsci.component_item_id),

Line 5099: bom_inventory_components bic

5095: AND bsci.process_flag = G_CM_TO_BE_PROCESSED
5096: AND bsci.transaction_type in ('DELETE', 'UPDATE')
5097: AND exists (SELECT 1
5098: FROM bom_substitute_components bsc,
5099: bom_inventory_components bic
5100: WHERE bsc.component_sequence_id = bic.component_sequence_id
5101: AND bsc.substitute_component_id = bsci.substitute_component_id
5102: AND bic.revised_item_sequence_id = p_revised_item_sequence_id
5103: AND bic.component_item_id = bsci.component_item_id);