View: OKL_BPD_MANUAL_TRX_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_MANUAL_TRX_UV

View Text

SELECT CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, I.ORG_ID ORG_ID
, I.DATE_INVOICED INVOICE_DATE
, CUSTACCT.NAME CUSTOMER_NAME
, SITE.NAME BILL_TO_SITE_LOCATION
, TO_CHAR (I.AMOUNT
, '99
, 999
, 999
, 999.99') INVOICE_AMOUNT
, LKUP.MEANING INVOICE_STATUS
, I.TRX_NUMBER TRX_NUMBER
, I.ID TRX_INVOICE_ID
, I.CURRENCY_CODE CURRENCY_CODE
, CHR.ID CONTRACT_ID
, DECODE(LKUP.LOOKUP_CODE
, 'WORKING'
, 'UPDENABLE'
, 'UPDDISABLE') UPDENABLEDISABLE
, DECODE(LKUP.LOOKUP_CODE
, 'WORKING'
, 'RMVENABLE'
, 'RMVDISABLE') RMVENABLEDISABLE
, I.TRX_STATUS_CODE
FROM OKL_TRX_AR_INVOICES_B I
, OKX_CUST_SITE_USES_V SITE
, OKX_CUSTOMER_ACCOUNTS_V CUSTACCT
, OKC_K_HEADERS_B CHR
, FND_LOOKUPS LKUP
WHERE CHR.ID = I.KHR_ID
AND SITE.CUST_ACCT_SITE_ID = I.IBT_ID
AND SITE.SITE_USE_CODE = 'BILL_TO'
AND CUSTACCT.ID1 = I.IXX_ID
AND LKUP.LOOKUP_TYPE = 'OKL_OP_MAN_BILLS_STATUS_TYPE'
AND LKUP.LOOKUP_CODE = I.TRX_STATUS_CODE

Columns