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: --Bug9281743

Line 1917: FROM HZ_PARTY_INTERFACE

1913: MAX(iy)
1914: FROM (
1915: SELECT nvl(to_number(to_char(min(last_update_date), 'YYYY')),0) iy
1916: , nvl(to_number(to_char(min(last_update_date), 'MM')),0) im
1917: FROM HZ_PARTY_INTERFACE
1918: WHERE content_source_type = 'DNB'
1919: AND status = 'P2'
1920: UNION
1921: SELECT nvl(to_number(to_char(min(last_update_date), 'YYYY')),0) iy

Line 2184: FROM HZ_PARTY_INTERFACE

2180: ,nvl(sum(decode(count(1),0,0,1)),0)
2181: ,l_enpty_count
2182: ,l_party_count
2183: ,p_system_date
2184: FROM HZ_PARTY_INTERFACE
2185: WHERE status = 'P2'
2186: AND to_char(last_update_date,'YYYY-MM') = to_char(p_system_date,'YYYY-MM')
2187: GROUP BY party_id;
2188: */

Line 2209: FROM HZ_PARTY_INTERFACE

2205: ,l_party_count
2206: ,p_system_date
2207: FROM (
2208: SELECT nvl(sum(decode(count(1),0,0,1)),0) org_enriched_for_period
2209: FROM HZ_PARTY_INTERFACE
2210: WHERE status = 'P2'
2211: AND content_source_type = 'DNB'
2212: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2213: GROUP BY party_id

Line 2272: FROM HZ_PARTY_INTERFACE

2268: /*
2269: UPDATE IMC_REPORTS_SUMMARY
2270: SET (org_cnt, total_cnt,total_pct, time_stamp) =
2271: (SELECT nvl(sum(decode(count(1),0,0,1)),0), l_enpty_count, l_party_count, p_system_date
2272: FROM HZ_PARTY_INTERFACE
2273: WHERE status = 'P2'
2274: AND to_char(last_update_date,'YYYY-MM') = to_char(p_system_date,'YYYY-MM')
2275: GROUP BY party_id)
2276: WHERE report_name = 'PARTY_ENRICH'

Line 2286: FROM HZ_PARTY_INTERFACE

2282: SET (org_cnt, total_cnt,total_pct, time_stamp) =
2283: (SELECT SUM(org_enriched_for_period), l_enpty_count, l_party_count, p_system_date
2284: FROM (
2285: SELECT nvl(sum(decode(count(1),0,0,1)),0) org_enriched_for_period
2286: FROM HZ_PARTY_INTERFACE
2287: WHERE status = 'P2'
2288: AND content_source_type = 'DNB'
2289: AND TO_CHAR(last_update_date,'YYYY-MM')= TO_CHAR(p_system_date,'YYYY-MM')
2290: GROUP BY party_id

Line 2368: FROM HZ_PARTY_INTERFACE

2364: ,nvl(sum(decode(count(1),0,0,1)),0)
2365: ,l_enpty_count
2366: ,l_party_count
2367: ,p_system_date
2368: FROM HZ_PARTY_INTERFACE
2369: WHERE status = 'P2'
2370: AND to_char(last_update_date,'YYYY-Q') = to_char(p_system_date,'YYYY-Q')
2371: GROUP BY party_id;
2372: */

Line 2393: FROM HZ_PARTY_INTERFACE

2389: ,l_party_count
2390: ,p_system_date
2391: FROM (
2392: SELECT nvl(SUM(decode(count(1),0,0,1)),0) org_enriched_for_period
2393: FROM HZ_PARTY_INTERFACE
2394: WHERE status = 'P2'
2395: AND content_source_type = 'DNB'
2396: AND to_char(last_update_date,'YYYY-Q') = to_char(p_system_date,'YYYY-Q')
2397: GROUP BY party_id

Line 2456: FROM HZ_PARTY_INTERFACE

2452: /*
2453: UPDATE IMC_REPORTS_SUMMARY
2454: SET (org_cnt, total_cnt,total_pct, time_stamp) =
2455: (SELECT nvl(sum(decode(count(1),0,0,1)),0), l_enpty_count, l_party_count, p_system_date
2456: FROM HZ_PARTY_INTERFACE
2457: WHERE status = 'P2'
2458: AND to_char(last_update_date,'YYYY-Q') = to_char(p_system_date,'YYYY-Q')
2459: GROUP BY party_id)
2460: WHERE report_name = 'PARTY_ENRICH'

Line 2469: FROM HZ_PARTY_INTERFACE

2465: SET (org_cnt, total_cnt,total_pct, time_stamp) =
2466: (SELECT SUM(org_enriched_for_period), l_enpty_count, l_party_count, p_system_date
2467: FROM (
2468: SELECT nvl(sum(decode(count(1),0,0,1)),0) org_enriched_for_period
2469: FROM HZ_PARTY_INTERFACE
2470: WHERE status = 'P2'
2471: AND content_source_type = 'DNB'
2472: AND TO_CHAR(last_update_date,'YYYY-Q')= TO_CHAR(p_system_date,'YYYY-Q')
2473: GROUP BY party_id

Line 2572: FROM HZ_PARTY_INTERFACE

2568: */
2569: /*
2570: cursor get_enpty_count(l_party_type VARCHAR2, l_date DATE) is
2571: SELECT nvl(sum(decode(count(1),0,0,1)),0)
2572: FROM HZ_PARTY_INTERFACE
2573: WHERE status = 'P2'
2574: AND content_source_type = 'DNB'
2575: AND trunc(last_update_date) <= trunc(l_date)
2576: GROUP BY party_id;

Line 2582: FROM HZ_PARTY_INTERFACE

2578:
2579: cursor get_enpty_count(l_party_type VARCHAR2, l_date DATE) is
2580: SELECT SUM(total_org_enriched) FROM (
2581: SELECT nvl(sum(decode(count(1),0,0,1)),0) total_org_enriched
2582: FROM HZ_PARTY_INTERFACE
2583: WHERE status = 'P2'
2584: AND content_source_type = 'DNB'
2585: AND TRUNC(last_update_date) <= TRUNC(l_date)
2586: GROUP BY party_id