[Home] [Help]
View: JAI_PO_CURRENCY_CODE_V
View Text
SELECT CURRENCY_CODE
, PO_HEADER_ID
, TO_NUMBER(NULL) ORGANIZATION_ID
FROM PO_HEADERS_ALL UNION ALL SELECT CURRENCY_CODE
, TO_NUMBER(NULL)
, ORGANIZATION_ID
FROM GL_SETS_OF_BOOKS GSB
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE GSB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
Columns
Name |
CURRENCY_CODE |
PO_HEADER_ID |
ORGANIZATION_ID |