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.BOMFV_BOM_REVISIONS

Source

View Text - Preformatted


SELECT RV.REVISION ITEM_REVISION , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , RV.ECN_INITIATION_DATE ECO_INITIATION_DATE , RV.IMPLEMENTATION_DATE ECO_IMPLEMENTATION_DATE , RV.EFFECTIVITY_DATE START_EFFECTIVITY_DATE , RV.DESCRIPTION DESCRIPTION , RV.CHANGE_NOTICE , NULL , '_KF:INV:MSTK:SY1' "_KF:ITEM NAME" , '_KF:INV:MSTK:SY2' "_KF:ECO REVISED ITEM NAME" , RV.INVENTORY_ITEM_ID , RV.ORGANIZATION_ID , RV.REVISED_ITEM_SEQUENCE_ID , RV.LAST_UPDATE_DATE UPDATED_ON , RV.LAST_UPDATED_BY UPDATED_BY , RV.CREATION_DATE CREATED_ON , RV.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL,MTL_SYSTEM_ITEMS_B SY1,ENG_REVISED_ITEMS RI,MTL_SYSTEM_ITEMS_B SY2,MTL_PARAMETERS PA,MTL_ITEM_REVISIONS_B RV WHERE RI.REVISED_ITEM_ID = SY2.INVENTORY_ITEM_ID (+) AND RI.ORGANIZATION_ID = SY2.ORGANIZATION_ID (+) AND RV.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID (+) AND RV.ORGANIZATION_ID = PA.ORGANIZATION_ID AND RV.INVENTORY_ITEM_ID = SY1.INVENTORY_ITEM_ID AND RV.ORGANIZATION_ID = SY1.ORGANIZATION_ID AND RV.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:RV.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT RV.REVISION ITEM_REVISION
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, RV.ECN_INITIATION_DATE ECO_INITIATION_DATE
, RV.IMPLEMENTATION_DATE ECO_IMPLEMENTATION_DATE
, RV.EFFECTIVITY_DATE START_EFFECTIVITY_DATE
, RV.DESCRIPTION DESCRIPTION
, RV.CHANGE_NOTICE
, NULL
, '_KF:INV:MSTK:SY1' "_KF:ITEM NAME"
, '_KF:INV:MSTK:SY2' "_KF:ECO REVISED ITEM NAME"
, RV.INVENTORY_ITEM_ID
, RV.ORGANIZATION_ID
, RV.REVISED_ITEM_SEQUENCE_ID
, RV.LAST_UPDATE_DATE UPDATED_ON
, RV.LAST_UPDATED_BY UPDATED_BY
, RV.CREATION_DATE CREATED_ON
, RV.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS_B SY1
, ENG_REVISED_ITEMS RI
, MTL_SYSTEM_ITEMS_B SY2
, MTL_PARAMETERS PA
, MTL_ITEM_REVISIONS_B RV
WHERE RI.REVISED_ITEM_ID = SY2.INVENTORY_ITEM_ID (+)
AND RI.ORGANIZATION_ID = SY2.ORGANIZATION_ID (+)
AND RV.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID (+)
AND RV.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RV.INVENTORY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND RV.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND RV.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:RV.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY