VIEW: APPS.INVBV_FUTURE_ITEM_STATUSES

Source

View Text - Preformatted

SELECT '_KF:INV:MSTK:sy' , AL.NAME ,PA.ORGANIZATION_CODE ,PE.STATUS_CODE ,PE.EFFECTIVE_DATE ,PE.IMPLEMENTED_DATE ,'_LA:PE.PENDING_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,PE.INVENTORY_ITEM_ID ,PE.ORGANIZATION_ID ,PE.LAST_UPDATE_DATE ,PE.LAST_UPDATED_BY ,PE.CREATION_DATE ,PE.CREATED_BY FROM MTL_PARAMETERS PA, HR_ALL_ORGANIZATION_UNITS AL, MTL_SYSTEM_ITEMS SY, MTL_PENDING_ITEM_STATUS PE WHERE PE.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID AND PE.ORGANIZATION_ID = PA.ORGANIZATION_ID AND PE.ORGANIZATION_ID = SY.ORGANIZATION_ID AND PE.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:pe.organization_id' is not null with read only

View Text - HTML Formatted

SELECT '_KF:INV:MSTK:SY'
, AL.NAME
, PA.ORGANIZATION_CODE
, PE.STATUS_CODE
, PE.EFFECTIVE_DATE
, PE.IMPLEMENTED_DATE
, '_LA:PE.PENDING_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PE.INVENTORY_ITEM_ID
, PE.ORGANIZATION_ID
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATION_DATE
, PE.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, MTL_PENDING_ITEM_STATUS PE
WHERE PE.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND PE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND PE.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND PE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:PE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY