VIEW: APPS.OKL_BPD_AR_ADJUSTMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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