VIEW: APPS.OZF_X_INVOICES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)