INV_CONS_ADVICE_REVS_V

詳細

スキーマ: FUSION
オブジェクト所有者: INV
オブジェクト・タイプ: VIEW

列

名前
CONSUMPTION_HEADER_ID REVISION_NUMBER

名前

CONSUMPTION_HEADER_ID

REVISION_NUMBER

問合せ

SQL_Statement
select ical.consumption_header_id, ical.revision_number from inv_cons_advice_lines ical UNION select ical.consumption_header_id, icar.revision_number from inv_cons_advice_lines ical, inv_cons_advice_revisions icar where ical.consumption_line_id = icar.consumption_line_id

SQL_Statement

select ical.consumption_header_id, ical.revision_number from inv_cons_advice_lines ical

UNION

select ical.consumption_header_id, icar.revision_number from inv_cons_advice_lines ical, inv_cons_advice_revisions icar where ical.consumption_line_id = icar.consumption_line_id