eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_BPD_AR_INVOICES_V

Source

View Text - Preformatted


SELECT PAY_SCH.DUE_DATE DUE_DATE, RACTRX.TRX_DATE DATE_CONSOLIDATED, RACTRX.STATUS_TRX STATUS, RACTRX.CUST_TRX_TYPE_ID CLASS_ID, /*-- Need to join it with ra_cust_trx_types_all*/ RATRXTYPE.NAME CLASS, RACTRX.CUSTOMER_TRX_ID INVOICE_ID, RACTRX.TRX_NUMBER TRX_NUMBER, RACTRX.BILL_TO_CUSTOMER_ID IXX_ID, RACTRX.INVOICE_CURRENCY_CODE CURRENCY_CODE, PAY_SCH.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL, PAY_SCH.AMOUNT_DUE_REMAINING BALANCE, RACTRX.BILL_TO_SITE_USE_ID SITE_USE_ID, /*RACTRX.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID,*/ SITEUSE.CUST_ACCT_SITE_ID BILL_TO_SITE_USE_ID, RACTRX.RECEIPT_METHOD_ID RECEIPT_METHOD_ID, RACTRX.INTERFACE_HEADER_ATTRIBUTE2 INF_NAME, RACTRX.ORG_ID ORG_ID, PAY_SCH.CLASS PAY_SCH_CLASS, PAY_SCH.CUSTOMER_ID CUSTOMER_ID FROM RA_CUSTOMER_TRX_ALL RACTRX,OKX_CUST_SITE_USES_V SITEUSE,RA_CUST_TRX_TYPES_ALL RATRXTYPE,AR_PAYMENT_SCHEDULES_ALL PAY_SCH WHERE RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID and RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID and RACTRX.ORG_ID = RATRXTYPE.ORG_ID and RACTRX.BILL_TO_SITE_USE_ID = SITEUSE.ID1 (+)

View Text - HTML Formatted

SELECT PAY_SCH.DUE_DATE DUE_DATE
, RACTRX.TRX_DATE DATE_CONSOLIDATED
, RACTRX.STATUS_TRX STATUS
, RACTRX.CUST_TRX_TYPE_ID CLASS_ID
, /*-- NEED TO JOIN IT WITH RA_CUST_TRX_TYPES_ALL*/ RATRXTYPE.NAME CLASS
, RACTRX.CUSTOMER_TRX_ID INVOICE_ID
, RACTRX.TRX_NUMBER TRX_NUMBER
, RACTRX.BILL_TO_CUSTOMER_ID IXX_ID
, RACTRX.INVOICE_CURRENCY_CODE CURRENCY_CODE
, PAY_SCH.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, PAY_SCH.AMOUNT_DUE_REMAINING BALANCE
, RACTRX.BILL_TO_SITE_USE_ID SITE_USE_ID
, /*RACTRX.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, */ SITEUSE.CUST_ACCT_SITE_ID BILL_TO_SITE_USE_ID
, RACTRX.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, RACTRX.INTERFACE_HEADER_ATTRIBUTE2 INF_NAME
, RACTRX.ORG_ID ORG_ID
, PAY_SCH.CLASS PAY_SCH_CLASS
, PAY_SCH.CUSTOMER_ID CUSTOMER_ID
FROM RA_CUSTOMER_TRX_ALL RACTRX
, OKX_CUST_SITE_USES_V SITEUSE
, RA_CUST_TRX_TYPES_ALL RATRXTYPE
, AR_PAYMENT_SCHEDULES_ALL PAY_SCH
WHERE RACTRX.CUST_TRX_TYPE_ID = RATRXTYPE.CUST_TRX_TYPE_ID
AND RACTRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
AND RACTRX.ORG_ID = RATRXTYPE.ORG_ID
AND RACTRX.BILL_TO_SITE_USE_ID = SITEUSE.ID1 (+)