Product: | INV - Inventory |
---|---|
Description: | |
Implementation/DBA Data: | APPS.INVFV_FUTURE_ITEM_STATUSES |
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