APPS.IMC_REPORTS_SUMMARY_PKG dependencies on HZ_IMP_BATCH_SUMMARY

Line 1918: FROM hz_imp_batch_summary

1914: AND status = 'P2'
1915: UNION
1916: SELECT nvl(to_number(to_char(min(last_update_date), 'YYYY')),0) iy
1917: , nvl(to_number(to_char(min(last_update_date), 'MM')),0) im
1918: FROM hz_imp_batch_summary
1919: WHERE ORIGINAL_SYSTEM = 'DNB'
1920: AND IMPORT_STATUS <> 'PENDING'
1921: );
1922:

Line 2204: FROM hz_imp_batch_summary

2200: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2201: GROUP BY party_id
2202: UNION ALL
2203: SELECT nvl(SUM(parties_imported),0) org_enriched_for_period
2204: FROM hz_imp_batch_summary
2205: WHERE ORIGINAL_SYSTEM = 'DNB'
2206: AND IMPORT_STATUS <> 'PENDING'
2207: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2208: ) ;

Line 2281: FROM hz_imp_batch_summary

2277: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2278: GROUP BY party_id
2279: UNION ALL
2280: SELECT nvl(SUM(parties_imported),0) org_enriched_for_period
2281: FROM hz_imp_batch_summary
2282: WHERE ORIGINAL_SYSTEM = 'DNB'
2283: AND IMPORT_STATUS <> 'PENDING'
2284: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2285: )

Line 2388: FROM hz_imp_batch_summary

2384: AND to_char(last_update_date,'YYYY-Q') = to_char(p_system_date,'YYYY-Q')
2385: GROUP BY party_id
2386: UNION ALL
2387: SELECT nvl(SUM(parties_imported),0) org_enriched_for_period
2388: FROM hz_imp_batch_summary
2389: WHERE ORIGINAL_SYSTEM = 'DNB'
2390: AND IMPORT_STATUS <> 'PENDING'
2391: AND TO_CHAR(last_update_date,'YYYY-Q')= TO_CHAR(p_system_date,'YYYY-Q')
2392: );

Line 2464: FROM hz_imp_batch_summary

2460: AND TO_CHAR(last_update_date,'YYYY-Q')= TO_CHAR(p_system_date,'YYYY-Q')
2461: GROUP BY party_id
2462: UNION ALL
2463: SELECT nvl(SUM(parties_imported),0) org_enriched_for_period
2464: FROM hz_imp_batch_summary
2465: WHERE ORIGINAL_SYSTEM = 'DNB'
2466: AND IMPORT_STATUS <> 'PENDING'
2467: AND TO_CHAR(last_update_date,'YYYY-Q')= TO_CHAR(p_system_date,'YYYY-Q')
2468: )

Line 2577: FROM hz_imp_batch_summary

2573: AND TRUNC(last_update_date) <= TRUNC(l_date)
2574: GROUP BY party_id
2575: UNION ALL
2576: SELECT nvl(SUM(parties_imported),0) total_org_enriched
2577: FROM hz_imp_batch_summary
2578: WHERE ORIGINAL_SYSTEM = 'DNB'
2579: AND IMPORT_STATUS <> 'PENDING'
2580: AND TRUNC(last_update_date) <= TRUNC(l_date)
2581: );