APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 508: bom_substitute_components sc,

504: SELECT
505: sc.substitute_component_id,
506: it.concatenated_segments substitute_component_name
507: FROM
508: bom_substitute_components sc,
509: mtl_system_items_kfv it
510: WHERE
511: sc.substitute_component_id = it.inventory_item_id
512: AND it.organization_id = p_reference_org_id

Line 573: bom_substitute_components sc,

569: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.inverse_quantity) inverse_quantity
570: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.row_identifier ) row_identifier
571: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.program_id) program_id
572: FROM
573: bom_substitute_components sc,
574: mtl_system_items_kfv it
575: WHERE
576: sc.substitute_component_id = it.inventory_item_id AND
577: it.organization_id = p_reference_org_id AND

Line 3486: bom_substitute_components bsc,

3482: SELECT
3483: msi.concatenated_segments sub_comp_item_name ,
3484: bsc.substitute_component_id
3485: FROM bom_inventory_components bic,
3486: bom_substitute_components bsc,
3487: mtl_system_items_kfv msi
3488: WHERE bic.bill_sequence_id = p_src_bill_sequence_id
3489: AND bic.component_sequence_id = bsc.component_sequence_id
3490: AND bsc.substitute_component_id = msi.inventory_item_id

Line 4276: ,bom_substitute_components bsc

4272: FROM
4273: bom_inventory_components bic
4274: ,eng_revised_items eri
4275: ,mtl_item_flexfields mif
4276: ,bom_substitute_components bsc
4277: WHERE
4278: eri.change_id = p_change_id AND
4279: eri.revised_item_id = p_revised_item_id AND
4280: bic.component_item_id = p_component_id AND