VIEW: APPS.ENG_WEB_SUB_COMPS_V

Source

View Text - Preformatted

SELECT bsc.component_sequence_id, ml.meaning action, msi.concatenated_segments substitute_component, msi.padded_concatenated_segments, bsc.substitute_item_quantity, msi.primary_uom_code, msi.description from mtl_system_items_kfv msi, mfg_lookups ml, bom_substitute_components bsc, eng_revised_items eri, bom_inventory_components bic where bic.component_sequence_id = bsc.component_sequence_id and bic.revised_item_sequence_id = eri.revised_item_sequence_id and bsc.change_notice = eri.change_notice and msi.inventory_item_id = bsc.substitute_component_id and msi.organization_id = eri.organization_id and ml.lookup_code = bsc.acd_type and ml.lookup_type = 'ENG_REF_DESIG_ACTION'

View Text - HTML Formatted

SELECT BSC.COMPONENT_SEQUENCE_ID
, ML.MEANING ACTION
, MSI.CONCATENATED_SEGMENTS SUBSTITUTE_COMPONENT
, MSI.PADDED_CONCATENATED_SEGMENTS
, BSC.SUBSTITUTE_ITEM_QUANTITY
, MSI.PRIMARY_UOM_CODE
, MSI.DESCRIPTION
FROM MTL_SYSTEM_ITEMS_KFV MSI
, MFG_LOOKUPS ML
, BOM_SUBSTITUTE_COMPONENTS BSC
, ENG_REVISED_ITEMS ERI
, BOM_INVENTORY_COMPONENTS BIC
WHERE BIC.COMPONENT_SEQUENCE_ID = BSC.COMPONENT_SEQUENCE_ID
AND BIC.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID
AND BSC.CHANGE_NOTICE = ERI.CHANGE_NOTICE
AND MSI.INVENTORY_ITEM_ID = BSC.SUBSTITUTE_COMPONENT_ID
AND MSI.ORGANIZATION_ID = ERI.ORGANIZATION_ID
AND ML.LOOKUP_CODE = BSC.ACD_TYPE
AND ML.LOOKUP_TYPE = 'ENG_REF_DESIG_ACTION'