APPS.AD_ZD_MVIEW dependencies on AD_ZD_TABLE

Line 1623: ad_zd_table.ev_view_column(mvlc.column_name) as basecol

1619: select basecol, latestcol, mvlcol
1620: from
1621: (
1622: select
1623: ad_zd_table.ev_view_column(mvlc.column_name) as basecol
1624: , max(tabc.column_name) as latestcol
1625: , max(mvlc.column_name) as mvlcol
1626: from
1627: dba_tab_cols tabc

Line 1633: and ad_zd_table.ev_view_column(tabc.column_name) =

1629: where mvlc.owner = x_table_owner
1630: and mvlc.name = x_table_name
1631: and tabc.owner = mvlc.owner
1632: and tabc.table_name = mvlc.name
1633: and ad_zd_table.ev_view_column(tabc.column_name) =
1634: ad_zd_table.ev_view_column(mvlc.column_name)
1635: group by ad_zd_table.ev_view_column(mvlc.column_name)
1636: order by ad_zd_table.ev_view_column(mvlc.column_name)
1637: )

Line 1634: ad_zd_table.ev_view_column(mvlc.column_name)

1630: and mvlc.name = x_table_name
1631: and tabc.owner = mvlc.owner
1632: and tabc.table_name = mvlc.name
1633: and ad_zd_table.ev_view_column(tabc.column_name) =
1634: ad_zd_table.ev_view_column(mvlc.column_name)
1635: group by ad_zd_table.ev_view_column(mvlc.column_name)
1636: order by ad_zd_table.ev_view_column(mvlc.column_name)
1637: )
1638: where latestcol<>mvlcol;

Line 1635: group by ad_zd_table.ev_view_column(mvlc.column_name)

1631: and tabc.owner = mvlc.owner
1632: and tabc.table_name = mvlc.name
1633: and ad_zd_table.ev_view_column(tabc.column_name) =
1634: ad_zd_table.ev_view_column(mvlc.column_name)
1635: group by ad_zd_table.ev_view_column(mvlc.column_name)
1636: order by ad_zd_table.ev_view_column(mvlc.column_name)
1637: )
1638: where latestcol<>mvlcol;
1639:

Line 1636: order by ad_zd_table.ev_view_column(mvlc.column_name)

1632: and tabc.table_name = mvlc.name
1633: and ad_zd_table.ev_view_column(tabc.column_name) =
1634: ad_zd_table.ev_view_column(mvlc.column_name)
1635: group by ad_zd_table.ev_view_column(mvlc.column_name)
1636: order by ad_zd_table.ev_view_column(mvlc.column_name)
1637: )
1638: where latestcol<>mvlcol;
1639:
1640: l_first boolean := TRUE;