VIEW: APPS.OKL_AR_ADJ_KHR_IA_REF_VL

Source

View Text - Preformatted

SELECT ajl.receivables_adjustment_id receivables_adjustment_id ,ajl.id okl_ajl_id ,rxhl.language okl_language ,rxhl.contract_status okl_contract_status ,rxhl.inv_agrmnt_status okl_inv_agrmnt_status ,rxll.stream_type_name okl_stream_type_name ,rxhl.transaction_type_name okl_transaction_type_name ,rxll.trans_line_description okl_trans_line_description ,rxll.inventory_org_name okl_inventory_org_name FROM OKL_EXT_AR_HEADER_SOURCES_B RXH,OKL_EXT_AR_LINE_SOURCES_B RXL,OKL_EXT_AR_HEADER_SOURCES_TL RXHL,OKL_EXT_AR_LINE_SOURCES_TL RXLL,OKL_TXL_ADJSTS_LNS_ALL_B AJL WHERE rxl.source_table = 'OKL_TXL_ADJSTS_LNS_B' AND rxl.source_id = ajl.id AND rxh.header_extension_id = rxhl.header_extension_id AND rxl.line_extension_id = rxll.line_extension_id AND rxl.header_extension_id = rxh.header_extension_id AND rxhl.language = rxll.language

View Text - HTML Formatted

SELECT AJL.RECEIVABLES_ADJUSTMENT_ID RECEIVABLES_ADJUSTMENT_ID
, AJL.ID OKL_AJL_ID
, RXHL.LANGUAGE OKL_LANGUAGE
, RXHL.CONTRACT_STATUS OKL_CONTRACT_STATUS
, RXHL.INV_AGRMNT_STATUS OKL_INV_AGRMNT_STATUS
, RXLL.STREAM_TYPE_NAME OKL_STREAM_TYPE_NAME
, RXHL.TRANSACTION_TYPE_NAME OKL_TRANSACTION_TYPE_NAME
, RXLL.TRANS_LINE_DESCRIPTION OKL_TRANS_LINE_DESCRIPTION
, RXLL.INVENTORY_ORG_NAME OKL_INVENTORY_ORG_NAME
FROM OKL_EXT_AR_HEADER_SOURCES_B RXH
, OKL_EXT_AR_LINE_SOURCES_B RXL
, OKL_EXT_AR_HEADER_SOURCES_TL RXHL
, OKL_EXT_AR_LINE_SOURCES_TL RXLL
, OKL_TXL_ADJSTS_LNS_ALL_B AJL
WHERE RXL.SOURCE_TABLE = 'OKL_TXL_ADJSTS_LNS_B'
AND RXL.SOURCE_ID = AJL.ID
AND RXH.HEADER_EXTENSION_ID = RXHL.HEADER_EXTENSION_ID
AND RXL.LINE_EXTENSION_ID = RXLL.LINE_EXTENSION_ID
AND RXL.HEADER_EXTENSION_ID = RXH.HEADER_EXTENSION_ID
AND RXHL.LANGUAGE = RXLL.LANGUAGE