[Home] [Help]
View: MTL_ORG_REPORT_TEMP_FK_V
View Text
SELECT A.ROWID ROW_ID
, A.REPORT_ID
, A.ORG_REPORT_ORDER
, A.ORGANIZATION_ID
, B.ORGANIZATION_CODE
, B.ORGANIZATION_NAME
FROM MTL_ORG_REPORT_TEMP A
, ORG_ORGANIZATION_DEFINITIONS B
WHERE B.ORGANIZATION_ID = A.ORGANIZATION_ID
Columns
Name |
ROW_ID |
REPORT_ID |
ORG_REPORT_ORDER |
ORGANIZATION_ID |
ORGANIZATION_CODE |
ORGANIZATION_NAME |