機械翻訳について

CJM_XLA_AR_TRX_LINES_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: CJM

• オブジェクト・タイプ: VIEW

列

名前
CUSTOMER_TRX_LINE_ID WAREHOUSE_ID WAREHOUSE_CODE WAREHOUSE_NAME

問合せ

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