APPS.IMC_REPORTS_SUMMARY_PKG dependencies on HZ_IMP_BATCH_SUMMARY

Line 1923: FROM hz_imp_batch_summary

1919: AND status = 'P2'
1920: UNION
1921: SELECT nvl(to_number(to_char(min(last_update_date), 'YYYY')),0) iy
1922: , nvl(to_number(to_char(min(last_update_date), 'MM')),0) im
1923: FROM hz_imp_batch_summary
1924: WHERE ORIGINAL_SYSTEM = 'DNB'
1925: AND IMPORT_STATUS <> 'PENDING'
1926: );
1927:

Line 2216: FROM hz_imp_batch_summary

2212: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2213: GROUP BY party_id
2214: UNION ALL
2215: SELECT nvl(SUM(parties_imported),0) org_enriched_for_period
2216: FROM hz_imp_batch_summary
2217: WHERE ORIGINAL_SYSTEM = 'DNB'
2218: AND IMPORT_STATUS <> 'PENDING'
2219: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2220: ) ;

Line 2293: FROM hz_imp_batch_summary

2289: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2290: GROUP BY party_id
2291: UNION ALL
2292: SELECT nvl(SUM(parties_imported),0) org_enriched_for_period
2293: FROM hz_imp_batch_summary
2294: WHERE ORIGINAL_SYSTEM = 'DNB'
2295: AND IMPORT_STATUS <> 'PENDING'
2296: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2297: )

Line 2400: FROM hz_imp_batch_summary

2396: AND to_char(last_update_date,'YYYY-Q') = to_char(p_system_date,'YYYY-Q')
2397: GROUP BY party_id
2398: UNION ALL
2399: SELECT nvl(SUM(parties_imported),0) org_enriched_for_period
2400: FROM hz_imp_batch_summary
2401: WHERE ORIGINAL_SYSTEM = 'DNB'
2402: AND IMPORT_STATUS <> 'PENDING'
2403: AND TO_CHAR(last_update_date,'YYYY-Q')= TO_CHAR(p_system_date,'YYYY-Q')
2404: );

Line 2476: FROM hz_imp_batch_summary

2472: AND TO_CHAR(last_update_date,'YYYY-Q')= TO_CHAR(p_system_date,'YYYY-Q')
2473: GROUP BY party_id
2474: UNION ALL
2475: SELECT nvl(SUM(parties_imported),0) org_enriched_for_period
2476: FROM hz_imp_batch_summary
2477: WHERE ORIGINAL_SYSTEM = 'DNB'
2478: AND IMPORT_STATUS <> 'PENDING'
2479: AND TO_CHAR(last_update_date,'YYYY-Q')= TO_CHAR(p_system_date,'YYYY-Q')
2480: )

Line 2589: FROM hz_imp_batch_summary

2585: AND TRUNC(last_update_date) <= TRUNC(l_date)
2586: GROUP BY party_id
2587: UNION ALL
2588: SELECT nvl(SUM(parties_imported),0) total_org_enriched
2589: FROM hz_imp_batch_summary
2590: WHERE ORIGINAL_SYSTEM = 'DNB'
2591: AND IMPORT_STATUS <> 'PENDING'
2592: AND TRUNC(last_update_date) <= TRUNC(l_date)
2593: );