APPS.BIM_I_SGMT_FACTS_PKG dependencies on FII_TIME_DAY

Line 157: FROM fii_Time_Day

153: --- Validate Time Dimension Tables
154:
155: SELECT ent_year_start_date
156: INTO l_year_start_date
157: FROM fii_Time_Day
158: WHERE report_date = trunc(l_end_date);
159:
160: IF l_year_start_date IS NULL THEN
161:

Line 552: ' ,fii_time_day b ' ||

548: ' ,0 ptd_qtr_cnt ' ||
549: ' ,0 ptd_month_cnt ' ||
550: ' ,0 ptd_year_cnt ' ||
551: ' FROM party_orders a ' ||
552: ' ,fii_time_day b ' ||
553: ' WHERE a.transaction_create_date = b.report_date ' ||
554: ' GROUP BY b.report_date_julian, a.transaction_create_date ,a.party_id,a.segment_id,b.week_id ' ||
555: ' UNION ALL ' ||
556: ' SELECT ' ||

Line 569: ' ,fii_time_day b ' ||

565: ' END ' ||
566: ' ) ptd_month_cnt ' ||
567: ' ,0 ptd_year_cnt ' ||
568: ' FROM party_orders a ' ||
569: ' ,fii_time_day b ' ||
570: ' WHERE a.transaction_create_date = b.report_date ' ||
571: ' GROUP BY b.report_date_julian, a.transaction_create_date,a.party_id,a.segment_id, b.ent_period_id ' ||
572: ' UNION ALL ' ||
573: ' SELECT ' ||

Line 586: ' ,fii_time_day b ' ||

582: ' ) ptd_qtr_cnt ' ||
583: ' ,0 ptd_month_cnt ' ||
584: ' ,0 ptd_year_cnt ' ||
585: ' FROM party_orders a ' ||
586: ' ,fii_time_day b ' ||
587: ' WHERE a.transaction_create_date = b.report_date ' ||
588: ' GROUP BY b.report_date_julian, a.transaction_create_date,a.party_id,a.segment_id,b.ent_qtr_id ' ||
589: ' UNION ALL ' ||
590: ' SELECT ' ||

Line 603: ' ,fii_time_day b ' ||

599: ' ELSE 0 ' ||
600: ' END ' ||
601: ' ) ptd_year_cnt ' ||
602: ' FROM party_orders a ' ||
603: ' ,fii_time_day b ' ||
604: ' WHERE a.transaction_create_date = b.report_date ' ||
605: ' GROUP BY b.report_date_julian,a.transaction_create_date ,a.party_id,a.segment_id, b.ent_year_id ' ||
606: ' ) ) ' ||
607: ' WHERE ptd_year_cnt >0 or ptd_qtr_cnt>0 or ptd_month_cnt>0 or ptd_week_cnt >0 ' ||

Line 944: ' ,fii_time_day b ' ||

940: ' ,0 ptd_qtr_cnt ' ||
941: ' ,0 ptd_month_cnt ' ||
942: ' ,0 ptd_year_cnt ' ||
943: ' FROM party_orders a ' ||
944: ' ,fii_time_day b ' ||
945: ' WHERE a.transaction_create_date = b.report_date ' ||
946: ' GROUP BY b.report_date_julian, a.transaction_create_date ,a.party_id,a.segment_id,b.week_id ' ||
947: ' UNION ALL ' ||
948: ' SELECT ' ||

Line 961: ' ,fii_time_day b ' ||

957: ' END ' ||
958: ' ) ptd_month_cnt ' ||
959: ' ,0 ptd_year_cnt ' ||
960: ' FROM party_orders a ' ||
961: ' ,fii_time_day b ' ||
962: ' WHERE a.transaction_create_date = b.report_date ' ||
963: ' GROUP BY b.report_date_julian, a.transaction_create_date,a.party_id,a.segment_id, b.ent_period_id ' ||
964: ' UNION ALL ' ||
965: ' SELECT ' ||

Line 978: ' ,fii_time_day b ' ||

974: ' ) ptd_qtr_cnt ' ||
975: ' ,0 ptd_month_cnt ' ||
976: ' ,0 ptd_year_cnt ' ||
977: ' FROM party_orders a ' ||
978: ' ,fii_time_day b ' ||
979: ' WHERE a.transaction_create_date = b.report_date ' ||
980: ' GROUP BY b.report_date_julian, a.transaction_create_date,a.party_id,a.segment_id,b.ent_qtr_id ' ||
981: ' UNION ALL ' ||
982: ' SELECT ' ||

Line 995: ' ,fii_time_day b ' ||

991: ' ELSE 0 ' ||
992: ' END ' ||
993: ' ) ptd_year_cnt ' ||
994: ' FROM party_orders a ' ||
995: ' ,fii_time_day b ' ||
996: ' WHERE a.transaction_create_date = b.report_date ' ||
997: ' GROUP BY b.report_date_julian,a.transaction_create_date ,a.party_id,a.segment_id, b.ent_year_id ' ||
998: ' ) ) ' ||
999: ' WHERE transaction_create_date >= trunc(to_date('''||p_start_date||''',''DD-MON-YY''),''MONTH'')'||