APPS.IMC_REPORTS_SUMMARY_PKG dependencies on HZ_PARTY_INTERFACE

Line 1901: FROM HZ_PARTY_INTERFACE

1897: SELECT nvl(to_number(to_char(min(last_update_date), 'YYYY')),0) iy
1898: , nvl(to_number(to_char(min(last_update_date), 'MM')),0) im
1899: , to_number(to_char(l_system_date, 'YYYY')) xy
1900: , to_number(to_char(l_system_date, 'MM')) xm
1901: FROM HZ_PARTY_INTERFACE
1902: WHERE content_source_type = 'DNB'
1903: AND status = 'P2';
1904: */
1905: CURSOR min_max_year_month(l_system_date DATE) IS

Line 1912: FROM HZ_PARTY_INTERFACE

1908: TO_NUMBER(to_char(l_system_date, 'MM')) xm
1909: FROM (
1910: SELECT nvl(to_number(to_char(min(last_update_date), 'YYYY')),0) iy
1911: , nvl(to_number(to_char(min(last_update_date), 'MM')),0) im
1912: FROM HZ_PARTY_INTERFACE
1913: WHERE content_source_type = 'DNB'
1914: AND status = 'P2'
1915: UNION
1916: SELECT nvl(to_number(to_char(min(last_update_date), 'YYYY')),0) iy

Line 2172: FROM HZ_PARTY_INTERFACE

2168: ,nvl(sum(decode(count(1),0,0,1)),0)
2169: ,l_enpty_count
2170: ,l_party_count
2171: ,p_system_date
2172: FROM HZ_PARTY_INTERFACE
2173: WHERE status = 'P2'
2174: AND to_char(last_update_date,'YYYY-MM') = to_char(p_system_date,'YYYY-MM')
2175: GROUP BY party_id;
2176: */

Line 2197: FROM HZ_PARTY_INTERFACE

2193: ,l_party_count
2194: ,p_system_date
2195: FROM (
2196: SELECT nvl(sum(decode(count(1),0,0,1)),0) org_enriched_for_period
2197: FROM HZ_PARTY_INTERFACE
2198: WHERE status = 'P2'
2199: AND content_source_type = 'DNB'
2200: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2201: GROUP BY party_id

Line 2260: FROM HZ_PARTY_INTERFACE

2256: /*
2257: UPDATE IMC_REPORTS_SUMMARY
2258: SET (org_cnt, total_cnt,total_pct, time_stamp) =
2259: (SELECT nvl(sum(decode(count(1),0,0,1)),0), l_enpty_count, l_party_count, p_system_date
2260: FROM HZ_PARTY_INTERFACE
2261: WHERE status = 'P2'
2262: AND to_char(last_update_date,'YYYY-MM') = to_char(p_system_date,'YYYY-MM')
2263: GROUP BY party_id)
2264: WHERE report_name = 'PARTY_ENRICH'

Line 2274: FROM HZ_PARTY_INTERFACE

2270: SET (org_cnt, total_cnt,total_pct, time_stamp) =
2271: (SELECT SUM(org_enriched_for_period), l_enpty_count, l_party_count, p_system_date
2272: FROM (
2273: SELECT nvl(sum(decode(count(1),0,0,1)),0) org_enriched_for_period
2274: FROM HZ_PARTY_INTERFACE
2275: WHERE status = 'P2'
2276: AND content_source_type = 'DNB'
2277: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2278: GROUP BY party_id

Line 2356: FROM HZ_PARTY_INTERFACE

2352: ,nvl(sum(decode(count(1),0,0,1)),0)
2353: ,l_enpty_count
2354: ,l_party_count
2355: ,p_system_date
2356: FROM HZ_PARTY_INTERFACE
2357: WHERE status = 'P2'
2358: AND to_char(last_update_date,'YYYY-Q') = to_char(p_system_date,'YYYY-Q')
2359: GROUP BY party_id;
2360: */

Line 2381: FROM HZ_PARTY_INTERFACE

2377: ,l_party_count
2378: ,p_system_date
2379: FROM (
2380: SELECT nvl(SUM(decode(count(1),0,0,1)),0) org_enriched_for_period
2381: FROM HZ_PARTY_INTERFACE
2382: WHERE status = 'P2'
2383: AND content_source_type = 'DNB'
2384: AND to_char(last_update_date,'YYYY-Q') = to_char(p_system_date,'YYYY-Q')
2385: GROUP BY party_id

Line 2444: FROM HZ_PARTY_INTERFACE

2440: /*
2441: UPDATE IMC_REPORTS_SUMMARY
2442: SET (org_cnt, total_cnt,total_pct, time_stamp) =
2443: (SELECT nvl(sum(decode(count(1),0,0,1)),0), l_enpty_count, l_party_count, p_system_date
2444: FROM HZ_PARTY_INTERFACE
2445: WHERE status = 'P2'
2446: AND to_char(last_update_date,'YYYY-Q') = to_char(p_system_date,'YYYY-Q')
2447: GROUP BY party_id)
2448: WHERE report_name = 'PARTY_ENRICH'

Line 2457: FROM HZ_PARTY_INTERFACE

2453: SET (org_cnt, total_cnt,total_pct, time_stamp) =
2454: (SELECT SUM(org_enriched_for_period), l_enpty_count, l_party_count, p_system_date
2455: FROM (
2456: SELECT nvl(sum(decode(count(1),0,0,1)),0) org_enriched_for_period
2457: FROM HZ_PARTY_INTERFACE
2458: WHERE status = 'P2'
2459: AND content_source_type = 'DNB'
2460: AND TO_CHAR(last_update_date,'YYYY-Q')= TO_CHAR(p_system_date,'YYYY-Q')
2461: GROUP BY party_id

Line 2560: FROM HZ_PARTY_INTERFACE

2556: */
2557: /*
2558: cursor get_enpty_count(l_party_type VARCHAR2, l_date DATE) is
2559: SELECT nvl(sum(decode(count(1),0,0,1)),0)
2560: FROM HZ_PARTY_INTERFACE
2561: WHERE status = 'P2'
2562: AND content_source_type = 'DNB'
2563: AND trunc(last_update_date) <= trunc(l_date)
2564: GROUP BY party_id;

Line 2570: FROM HZ_PARTY_INTERFACE

2566:
2567: cursor get_enpty_count(l_party_type VARCHAR2, l_date DATE) is
2568: SELECT SUM(total_org_enriched) FROM (
2569: SELECT nvl(sum(decode(count(1),0,0,1)),0) total_org_enriched
2570: FROM HZ_PARTY_INTERFACE
2571: WHERE status = 'P2'
2572: AND content_source_type = 'DNB'
2573: AND TRUNC(last_update_date) <= TRUNC(l_date)
2574: GROUP BY party_id