VIEW: APPS.OKL_BPD_MANUAL_TRX_UV

Source

View Text - Preformatted

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 AND I.OKL_SOURCE_BILLING_TRX = 'MANUAL_INVOICE'

View Text - HTML Formatted

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
AND I.OKL_SOURCE_BILLING_TRX = 'MANUAL_INVOICE'