[Home] [Help]
View: MTL_ITEM_REVISIONS_ORG_VAL_V
View Text
SELECT MIR.REVISION
, MIR.REVISION_ID
, MIR.ORGANIZATION_ID
, MIR.INVENTORY_ITEM_ID
FROM ORG_ORGANIZATION_DEFINITIONS OOD
, MTL_ITEM_REVISIONS_B MIR
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE MIR.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND SYSDATE < NVL(OOD.DISABLE_DATE
, SYSDATE+1)
AND FSP.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
Columns
Name |
REVISION |
REVISION_ID |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |