View: OKL_BPD_AR_INVOICES_V

Product:	OKL - Leasing and Finance Management
Description:	View to display Payable Invoice details
Implementation/DBA Data:	APPS.OKL_BPD_AR_INVOICES_V

View Text

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 (+)

Columns