VIEW: APPS.OKL_BPD_AR_ADJ_LINES_V

Source

View Text - Preformatted

SELECT ARADJ.ADJUSTMENT_ID ID, NULL DESCRIPTION, AJL.AMOUNT AMOUNT, STY.CODE STREAM_TYPE, ARADJ.ADJUSTMENT_ID TRANSACTION_ID, 'AR_ADJUSTMENTS_V' SOURCE_TABLE, STY.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE, AJL.KHR_ID KHR_ID, NULL CUSTOMER_TRX_ID, OKCHDR.CONTRACT_NUMBER CONTRACT_NUMBER, AJL.ID LINE_ID, ARADJ.INVOICE_CURRENCY_CODE CURRENCY_CODE, STY.NAME STREAM_TYPE_NAME, ROW_NUMBER() OVER (PARTITION BY AJL.ID order by AJL.ID) AS LINE_NUMBER FROM OKL_TXL_ADJSTS_LNS_B AJL, AR_ADJUSTMENTS_V ARADJ, OKL_STRM_TYPE_V STY, OKC_K_HEADERS_B OKCHDR WHERE AJL.STY_ID = STY.ID AND AJL.RECEIVABLES_ADJUSTMENT_ID = ARADJ.ADJUSTMENT_ID AND AJL.KHR_ID = OKCHDR.ID

View Text - HTML Formatted

SELECT ARADJ.ADJUSTMENT_ID ID
, NULL DESCRIPTION
, AJL.AMOUNT AMOUNT
, STY.CODE STREAM_TYPE
, ARADJ.ADJUSTMENT_ID TRANSACTION_ID
, 'AR_ADJUSTMENTS_V' SOURCE_TABLE
, STY.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE
, AJL.KHR_ID KHR_ID
, NULL CUSTOMER_TRX_ID
, OKCHDR.CONTRACT_NUMBER CONTRACT_NUMBER
, AJL.ID LINE_ID
, ARADJ.INVOICE_CURRENCY_CODE CURRENCY_CODE
, STY.NAME STREAM_TYPE_NAME
, ROW_NUMBER() OVER (PARTITION BY AJL.ID ORDER BY AJL.ID) AS LINE_NUMBER
FROM OKL_TXL_ADJSTS_LNS_B AJL
, AR_ADJUSTMENTS_V ARADJ
, OKL_STRM_TYPE_V STY
, OKC_K_HEADERS_B OKCHDR
WHERE AJL.STY_ID = STY.ID
AND AJL.RECEIVABLES_ADJUSTMENT_ID = ARADJ.ADJUSTMENT_ID
AND AJL.KHR_ID = OKCHDR.ID