APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 1082: bom_substitute_components sc,

1078: SELECT
1079: sc.substitute_component_id,
1080: it.concatenated_segments substitute_component_name
1081: FROM
1082: bom_substitute_components sc,
1083: mtl_system_items_kfv it
1084: WHERE
1085: sc.substitute_component_id = it.inventory_item_id
1086: AND it.organization_id = p_reference_org_id

Line 1147: bom_substitute_components sc,

1143: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.inverse_quantity) inverse_quantity
1144: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.row_identifier ) row_identifier
1145: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.program_id) program_id
1146: FROM
1147: bom_substitute_components sc,
1148: mtl_system_items_kfv it
1149: WHERE
1150: sc.substitute_component_id = it.inventory_item_id AND
1151: it.organization_id = p_reference_org_id AND

Line 3667: bom_substitute_components bsc,

3663: SELECT
3664: msi.concatenated_segments sub_comp_item_name ,
3665: bsc.substitute_component_id
3666: FROM bom_inventory_components bic,
3667: bom_substitute_components bsc,
3668: mtl_system_items_kfv msi
3669: WHERE bic.bill_sequence_id = p_src_bill_sequence_id
3670: AND bic.component_sequence_id = bsc.component_sequence_id
3671: AND bsc.substitute_component_id = msi.inventory_item_id

Line 5219: ,bom_substitute_components bsc

5215: FROM
5216: bom_inventory_components bic
5217: ,eng_revised_items eri
5218: ,mtl_item_flexfields mif
5219: ,bom_substitute_components bsc
5220: WHERE
5221: eri.change_id = p_change_id AND
5222: eri.revised_item_id = p_revised_item_id AND
5223: bic.component_item_id = p_component_id AND