eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BOMBV_SUBSTITUTE_BOM_COMPS

Source

View Text - Preformatted


SELECT CO.EFFECTIVITY_DATE START_EFFECTIVITY_DATE , CO.OPERATION_SEQ_NUM OPERATION_SEQUENCE_NUMBER , BI.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE , '_KF:INV:MSTK:SY2' "_KF:COMPONENT_ITEM_NAME" , '_KF:INV:MTLL:SY1' "_KF:BILL_ITEM_NAME" , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , SU.SUBSTITUTE_ITEM_QUANTITY SUBSTITUTE_ITEM_QUANTITY , '_LA:SU.ACD_TYPE:MFG_LOOKUPS:ECG_ACTION:MEANING' , SU.SUBSTITUTE_COMPONENT_ID , SU.COMPONENT_SEQUENCE_ID , BI.ORGANIZATION_ID , SU.CHANGE_NOTICE , SU.LAST_UPDATE_DATE UPDATED_ON , SU.LAST_UPDATED_BY UPDATED_BY , SU.CREATION_DATE CREATED_ON , SU.CREATED_BY FROM BOM_INVENTORY_COMPONENTS CO, MTL_SYSTEM_ITEMS SY3, MTL_SYSTEM_ITEMS SY2, MTL_SYSTEM_ITEMS SY1, MTL_PARAMETERS PA, HR_ALL_ORGANIZATION_UNITS AL, BOM_BILL_OF_MATERIALS BI, BOM_SUBSTITUTE_COMPONENTS SU WHERE SU.SUBSTITUTE_COMPONENT_ID = SY3.INVENTORY_ITEM_ID AND BI.ORGANIZATION_ID = SY3.ORGANIZATION_ID AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID AND CO.COMPONENT_ITEM_ID = SY2.INVENTORY_ITEM_ID AND BI.ORGANIZATION_ID = SY2.ORGANIZATION_ID AND BI.ASSEMBLY_ITEM_ID = SY1.INVENTORY_ITEM_ID AND BI.ORGANIZATION_ID = SY1.ORGANIZATION_ID AND CO.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID AND SU.COMPONENT_SEQUENCE_ID = CO.COMPONENT_SEQUENCE_ID AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT CO.EFFECTIVITY_DATE START_EFFECTIVITY_DATE
, CO.OPERATION_SEQ_NUM OPERATION_SEQUENCE_NUMBER
, BI.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE
, '_KF:INV:MSTK:SY2' "_KF:COMPONENT_ITEM_NAME"
, '_KF:INV:MTLL:SY1' "_KF:BILL_ITEM_NAME"
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, SU.SUBSTITUTE_ITEM_QUANTITY SUBSTITUTE_ITEM_QUANTITY
, '_LA:SU.ACD_TYPE:MFG_LOOKUPS:ECG_ACTION:MEANING'
, SU.SUBSTITUTE_COMPONENT_ID
, SU.COMPONENT_SEQUENCE_ID
, BI.ORGANIZATION_ID
, SU.CHANGE_NOTICE
, SU.LAST_UPDATE_DATE UPDATED_ON
, SU.LAST_UPDATED_BY UPDATED_BY
, SU.CREATION_DATE CREATED_ON
, SU.CREATED_BY
FROM BOM_INVENTORY_COMPONENTS CO
, MTL_SYSTEM_ITEMS SY3
, MTL_SYSTEM_ITEMS SY2
, MTL_SYSTEM_ITEMS SY1
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, BOM_BILL_OF_MATERIALS BI
, BOM_SUBSTITUTE_COMPONENTS SU
WHERE SU.SUBSTITUTE_COMPONENT_ID = SY3.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY3.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND CO.COMPONENT_ITEM_ID = SY2.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY2.ORGANIZATION_ID
AND BI.ASSEMBLY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND CO.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID
AND SU.COMPONENT_SEQUENCE_ID = CO.COMPONENT_SEQUENCE_ID
AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY