View: OKL_BPD_AR_ADJUSTMENTS_V

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

View Text

SELECT TO_CHAR(ARADJ.ADJUSTMENT_ID) ID
, OKHB.ID KHR_ID
, OKHB.CONTRACT_NUMBER CONTRACT_NUMBER
, 'REC' SOURCE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_VIEW_ACC_SOURCES'
, 'REC') SOURCE
, ARADJ.ADJUSTMENT_NUMBER TRANSACTION_NUMBER
, TRY.NAME TRANSACTION_TYPE
, NULL TRANSACTION_STATUS
, ARADJ.GL_DATE TRANSACTION_DATE
, ARADJ.COMMENTS DESCRIPTION
, OP.NAME PRODUCT_NAME
, ARADJ.AMOUNT AMOUNT
, ARADJ.INVOICE_CURRENCY_CODE CURRENCY_CODE
, NULL ACTUAL_DRAFT_STATUS_CODE
, NULL ACTUAL_DRAFT_STATUS
, ARADJ.AMOUNT TOTAL_TRANSACTION_AMOUNT
, NULL CHECK_ID
, ARADJ.ORG_ID ORG_ID
, ADJ.TRY_ID TRY_ID
, ARADJ.CUSTOMER_NUMBER ACCONT_NUMBER
, NULL TRX_TYPE
, ARADJ.SET_OF_BOOKS_ID LEDGER_ID
, NULL REPRESENTATION_CODE
FROM OKC_K_HEADERS_B OKHB
, OKL_K_HEADERS OKH
, OKL_PRODUCTS OP
, OKL_TRX_AR_ADJSTS_B ADJ
, OKL_TXL_ADJSTS_LNS_B AJL
, AR_ADJUSTMENTS_V ARADJ
, OKL_TRX_TYPES_TL TRY
WHERE ADJ.ID = AJL.ADJ_ID
AND AJL.RECEIVABLES_ADJUSTMENT_ID = ARADJ.ADJUSTMENT_ID
AND AJL.KHR_ID = OKH.ID
AND OKH.ID = OKHB.ID
AND OKH.PDT_ID = OP.ID
AND TRY.ID = ADJ.TRY_ID

Columns