APPS.ASO_BI_POPULATE_FACTS dependencies on ASO_BI_QUOTE_FACT_JOBS

Line 529: FROM ASO_BI_QUOTE_FACT_JOBS;

525: l_completed_cnt,
526: l_inprocess_cnt,
527: l_failed_cnt,
528: l_total_cnt
529: FROM ASO_BI_QUOTE_FACT_JOBS;
530:
531: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
532: BIS_COLLECTION_UTILITIES.Debug('Job Status - Unassigned:'||l_unassigned_cnt||
533: ' In Process:'||l_inprocess_cnt||' Completed:'||l_completed_cnt||

Line 617: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');

613: BIS_COLLECTION_UTILITIES.debug('Cleaning up the tables before processing starts.');
614: END IF;
615:
616: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
617: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');
618:
619: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
620: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 -
621: ONE_SECOND;

Line 1002: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');

998:
999: -- Truncate all the temp tables
1000: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_IDS');
1001: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1002: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_FACT_JOBS');
1003: ASO_BI_UTIL_PVT.Truncate_table('ASO_BI_LINE_IDS');
1004:
1005: l_from_date := TRUNC(TO_DATE(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
1006: l_to_date := TRUNC(TO_DATE(p_to_date,'YYYY/MM/DD HH24:MI:SS'))+ 1 -