View: OZF_X_INVOICES_V

Product:	OZF - Trade Management
Description:
Implementation/DBA Data:	APPS.OZF_X_INVOICES_V

View Text

SELECT TRX_NUMBER
, CUSTOMER_TRX_ID
, INVOICE_CURRENCY_CODE
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, TRX_DATE
, ACCTD_AMOUNT_DUE_REMAINING
, STATUS
, ORG_ID
, CLASS
, CUST_TRX_TYPE_ID
FROM AR_PAYMENT_SCHEDULES_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns