INV_CONS_ADVICE_REVS

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
CONSUMPTION_HEADER_ID REVISION_NUMBER

Name

CONSUMPTION_HEADER_ID

REVISION_NUMBER

Query

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