VIEW: APPS.BOMBV_BOM_REVISIONS

Source

View Text - Preformatted

SELECT RV.REVISION ITEM_REVISION , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , '_KF:INV:MSTK:SY' "_KF:ITEM_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 , 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 CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL , MTL_SYSTEM_ITEMS_B SY , MTL_PARAMETERS PA , MTL_ITEM_REVISIONS RV WHERE RV.ORGANIZATION_ID = SY.ORGANIZATION_ID AND RV.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID AND RV.ORGANIZATION_ID = PA.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
, '_KF:INV:MSTK:SY' "_KF:ITEM_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
, 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 CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS_B SY
, MTL_PARAMETERS PA
, MTL_ITEM_REVISIONS RV
WHERE RV.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND RV.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND RV.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RV.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:RV.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY