VIEW: APPS.JAI_CMN_BASE_CURRENCY_V

Source

View Text - Preformatted

SELECT base_currency_code, to_number(NULL) order_id FROM gl_plcy_mst a ,sy_orgn_mst b WHERE a.co_code=b.co_code UNION ALL SELECT billing_currency, order_id FROM op_ordr_hdr

View Text - HTML Formatted

SELECT BASE_CURRENCY_CODE
, TO_NUMBER(NULL) ORDER_ID
FROM GL_PLCY_MST A
, SY_ORGN_MST B
WHERE A.CO_CODE=B.CO_CODE UNION ALL SELECT BILLING_CURRENCY
, ORDER_ID
FROM OP_ORDR_HDR