CJM_XLA_AR_TRX_LINES_V

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
CUSTOMER_TRX_LINE_ID WAREHOUSE_ID WAREHOUSE_CODE WAREHOUSE_NAME

Query

SQL_Statement

SELECT trxl.customer_trx_line_id, trxl.warehouse_id, mp.organization_code warehouse_code, houft.name warehouse_name FROM hr_all_organization_units_f haouf, hr_organization_units_f_tl houft, inv_org_parameters mp, ra_customer_trx_lines_all trxl WHERE haouf.organization_id = trxl.warehouse_id AND haouf.organization_id = houft.organization_id AND houft.organization_id = mp.organization_id AND houft.language = userenv('LANG') AND TRUNC(SYSDATE) BETWEEN haouf.effective_start_date AND haouf.effective_end_date AND haouf.effective_start_date = houft.effective_start_date AND haouf.effective_end_date = houft.effective_end_date