DBA Data[Home] [Help]

VIEW: APPS.OKL_AR_ADJUSTMENTS_H_V

Source

View Text - Preformatted

SELECT event_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_ADJUSTMENTS_H_V adhv, okl_ar_adj_khr_ia_ref_vl oaaka WHERE adhv.ADJ_ID = oaaka.receivables_adjustment_id
View Text - HTML Formatted

SELECT EVENT_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_ADJUSTMENTS_H_V ADHV
, OKL_AR_ADJ_KHR_IA_REF_VL OAAKA
WHERE ADHV.ADJ_ID = OAAKA.RECEIVABLES_ADJUSTMENT_ID