SELECT rxh.source_id okl_ar_receipt_id ,rxhl.language okl_language ,rxhl.contract_status okl_contract_status FROM OKL_EXT_AR_HEADER_SOURCES_B RXH,OKL_EXT_AR_HEADER_SOURCES_TL RXHL WHERE rxh.source_table = 'AR_CASH_RECEIPTS' AND rxh.header_extension_id = rxhl.header_extension_id
SELECT RXH.SOURCE_ID OKL_AR_RECEIPT_ID
, RXHL.LANGUAGE OKL_LANGUAGE
, RXHL.CONTRACT_STATUS OKL_CONTRACT_STATUS
FROM OKL_EXT_AR_HEADER_SOURCES_B RXH
, OKL_EXT_AR_HEADER_SOURCES_TL RXHL
WHERE RXH.SOURCE_TABLE = 'AR_CASH_RECEIPTS'
AND RXH.HEADER_EXTENSION_ID = RXHL.HEADER_EXTENSION_ID
|
|
|