VIEW: APPS.JAI_PO_CURRENCY_CODE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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