DBA Data[Home] [Help]

APPS.HRI_BPL_TREND_ABS_SQL dependencies on STANDARD

Line 46: /* Snapshot/standard fact object */

42: /* Period Order */
43: /* Measure Columns */
44: /* FROM */
45: /* Table of periods to plot (sub-query) */
46: /* Snapshot/standard fact object */
47: /* WHERE */
48: /* Filter on selected manager */
49: /* Date filter (varies with snapshot/standard fact) */
50: /* Additional filters (e.g. top 4 countries) */

Line 49: /* Date filter (varies with snapshot/standard fact) */

45: /* Table of periods to plot (sub-query) */
46: /* Snapshot/standard fact object */
47: /* WHERE */
48: /* Filter on selected manager */
49: /* Date filter (varies with snapshot/standard fact) */
50: /* Additional filters (e.g. top 4 countries) */
51: /* */
52: /* An outer layer of SQL is added that brings in periods with no data by */
53: /* doing a UNION ALL with the trend periods table. */