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 |