[Home] [Help]
View: OKL_AR_INV_KHR_IA_REF_VL
View Text
SELECT TXD.ID OKL_TXD_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_TXD_AR_LN_DTLS_B TXD
WHERE RXL.SOURCE_TABLE = 'OKL_TXD_AR_LN_DTLS_B'
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 RXL.SOURCE_ID = TXD.ID
AND RXHL.LANGUAGE = RXLL.LANGUAGE
Columns
Name |
OKL_TXD_ID |
OKL_LANGUAGE |
OKL_CONTRACT_STATUS |
OKL_INV_AGRMNT_STATUS |
OKL_STREAM_TYPE_NAME |
OKL_TRANSACTION_TYPE_NAME |
OKL_TRANS_LINE_DESCRIPTION |
OKL_INVENTORY_ORG_NAME |