DBA Data[Home] [Help]

VIEW: APPS.OKL_AR_CM_LINES_L_V

Source

View Text - Preformatted

SELECT event_id ,line_number ,ledger_id ,okl_language language ,okl_contract_status ,okl_inv_agrmnt_status ,okl_stream_type_name ,okl_transaction_type_name ,okl_trans_line_description ,okl_inventory_org_name FROM AR_CM_LINES_L_V ACML, okl_ar_inv_khr_ia_ref_vl oaika WHERE ACML.CM_LINE_ATTR14 = oaika.okl_txd_id
View Text - HTML Formatted

SELECT EVENT_ID
, LINE_NUMBER
, LEDGER_ID
, OKL_LANGUAGE LANGUAGE
, OKL_CONTRACT_STATUS
, OKL_INV_AGRMNT_STATUS
, OKL_STREAM_TYPE_NAME
, OKL_TRANSACTION_TYPE_NAME
, OKL_TRANS_LINE_DESCRIPTION
, OKL_INVENTORY_ORG_NAME
FROM AR_CM_LINES_L_V ACML
, OKL_AR_INV_KHR_IA_REF_VL OAIKA
WHERE ACML.CM_LINE_ATTR14 = OAIKA.OKL_TXD_ID