INV_CONS_ADVICE_REVS_V
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: VIEW
Columns
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 |