eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PURGE_PKG dependencies on CHV_SCHEDULE_ITEMS

Line 348: chv_schedule_items csi,

344:
345: delete from chv_purge_schedule_list cpsl
346: where exists (select null
347: from chv_cum_periods ccp,
348: chv_schedule_items csi,
349: chv_schedule_headers csh,
350: chv_org_options coo
351: where ccp.organization_id = g_organization_id
352: and sysdate between ccp.cum_period_start_date and

Line 398: from chv_schedule_items csi,

394: -- test_chv_in_edi
395:
396: delete from chv_purge_schedule_list cpsl
397: where exists (select null
398: from chv_schedule_items csi,
399: ece_spso_items esi
400: where csi.schedule_item_id = cpsl.schedule_item_id
401: and csi.schedule_id = esi.schedule_id);
402:

Line 1309: from chv_schedule_items csi,

1305: double_check_flag)
1306: select csi.schedule_item_id,
1307: p_purge_name,
1308: 'Y'
1309: from chv_schedule_items csi,
1310: chv_schedule_headers csh,
1311: chv_purge_cum_list cpcl,
1312: chv_cum_periods ccp
1313: where csh.schedule_id = csi.schedule_id

Line 1362: from chv_schedule_items csi,

1358: double_check_flag)
1359: select csi.schedule_item_id,
1360: p_purge_name,
1361: 'Y'
1362: from chv_schedule_items csi,
1363: chv_schedule_headers csh
1364: where csh.schedule_id = csi.schedule_id
1365: and csh.last_update_date <= g_activity_date
1366: and NVL(csi.item_purge_status,'N') <> 'PURGED'

Line 2361: from chv_schedule_items csi,

2357: select MAX('Y')
2358: into range_inserted
2359: from sys.dual
2360: where exists (select null
2361: from chv_schedule_items csi,
2362: chv_schedule_headers csh,
2363: chv_history_schedules chs
2364: where csi.item_id = chs.item_id
2365: and csi.schedule_id = chs.schedule_id

Line 2415: chv_schedule_items csi

2411: csi.organization_id,
2412: p_purge_name
2413: from chv_purge_schedule_list cpsl,
2414: chv_schedule_headers csh,
2415: chv_schedule_items csi
2416: where cpsl.schedule_item_id = csi.schedule_item_id
2417: and csi.schedule_id = csh.schedule_id
2418: and cpsl.double_check_flag = 'Y'
2419: and cpsl.schedule_item_id between range_low and range_high;

Line 3676: and not exists (select 'schedule not purgeable' from chv_schedule_items csi,

3672:
3673: update chv_purge_schedule_list cpsl
3674: set double_check_flag = 'N'
3675: where cpsl.double_check_flag = 'Y'
3676: and not exists (select 'schedule not purgeable' from chv_schedule_items csi,
3677: chv_schedule_headers csh
3678: where csh.schedule_id = csi.schedule_id
3679: and csh.last_update_date <= g_activity_date
3680: and csi.organization_id = g_organization_id

Line 3737: and not exists (select null from chv_schedule_items csi,

3733:
3734: update chv_purge_schedule_list cpsl
3735: set double_check_flag = 'N'
3736: where cpsl.double_check_flag = 'Y'
3737: and not exists (select null from chv_schedule_items csi,
3738: chv_schedule_headers csh,
3739: chv_cum_periods ccp,
3740: chv_purge_cum_list cpcl
3741: where csh.schedule_id = csi.schedule_id

Line 3788: chv_schedule_items csi,

3784: set double_check_flag = 'N'
3785: where cpsl.double_check_flag = 'Y'
3786: and exists (select null
3787: from chv_cum_periods ccp,
3788: chv_schedule_items csi,
3789: chv_schedule_headers csh,
3790: chv_org_options coo
3791: where ccp.organization_id = g_organization_id
3792: and sysdate between ccp.cum_period_start_date and

Line 3839: from chv_schedule_items csi,

3835: update chv_purge_schedule_list cpsl
3836: set double_check_flag = 'N'
3837: where cpsl.double_check_flag = 'Y'
3838: and exists (select null
3839: from chv_schedule_items csi,
3840: ece_spso_items esi
3841: where csi.schedule_item_id = cpsl.schedule_item_id
3842: and csi.schedule_id = esi.schedule_id);
3843:

Line 3963: FROM chv_schedule_items

3959:
3960: --
3961: SELECT count(*)
3962: INTO chv_item_rows
3963: FROM chv_schedule_items
3964: WHERE NVL(item_purge_status,'N') <> 'PURGED';
3965:
3966: RETURN (TRUE);
3967:

Line 4043: chv_schedule_items = fp_chv_item_rows,

4039: chv_cum_periods = fp_chv_cum_rows,
4040: chv_horizontal_schedules = fp_chv_hor_rows,
4041: chv_item_orders = fp_chv_ord_rows,
4042: chv_schedule_headers = fp_chv_head_rows,
4043: chv_schedule_items = fp_chv_item_rows,
4044: ap_ae_lines = fp_ae_line_rows,
4045: ap_ae_headers = fp_ae_header_rows,
4046: ap_accounting_events = fp_accounting_event_rows,
4047: ap_chrg_allocations = fp_chrg_allocation_rows,

Line 5597: -- Update chv_schedule_items

5593: IF g_debug_switch in ('y','Y') THEN
5594: Print('(Purge_Schedules_by_Cum)'||debug_info);
5595: END IF;
5596:
5597: -- Update chv_schedule_items
5598:
5599: update chv_schedule_items csi
5600: set csi.item_purge_status = 'PURGED'
5601: where exists

Line 5599: update chv_schedule_items csi

5595: END IF;
5596:
5597: -- Update chv_schedule_items
5598:
5599: update chv_schedule_items csi
5600: set csi.item_purge_status = 'PURGED'
5601: where exists
5602: (select null
5603: from chv_purge_schedule_list cpsl

Line 5718: debug_info := 'chv_schedule_items';

5714: from chv_purge_cum_list cpcl
5715: where cpcl.cum_period_id = ccp.cum_period_id
5716: and cpcl.double_check_flag = 'Y');
5717:
5718: debug_info := 'chv_schedule_items';
5719: IF g_debug_switch in ('y','Y') THEN
5720: Print('(Purge_Schedules_by_Cum)'||debug_info);
5721: END IF;
5722:

Line 5723: -- delete_chv_schedule_items

5719: IF g_debug_switch in ('y','Y') THEN
5720: Print('(Purge_Schedules_by_Cum)'||debug_info);
5721: END IF;
5722:
5723: -- delete_chv_schedule_items
5724:
5725: /* bug2067536 Performance Bug
5726: */
5727: delete from chv_schedule_items csi

Line 5727: delete from chv_schedule_items csi

5723: -- delete_chv_schedule_items
5724:
5725: /* bug2067536 Performance Bug
5726: */
5727: delete from chv_schedule_items csi
5728: where not exists (select null
5729: from chv_schedule_items cs
5730: where csi.schedule_id = cs.schedule_id
5731: and nvl(cs.item_purge_status,'ACTIVE') <> 'PURGED');

Line 5729: from chv_schedule_items cs

5725: /* bug2067536 Performance Bug
5726: */
5727: delete from chv_schedule_items csi
5728: where not exists (select null
5729: from chv_schedule_items cs
5730: where csi.schedule_id = cs.schedule_id
5731: and nvl(cs.item_purge_status,'ACTIVE') <> 'PURGED');
5732:
5733: debug_info := 'chv_schedule_headers';

Line 5744: from chv_schedule_items csi

5740: /* bug2067536 Performance Bug
5741: */
5742: delete from chv_schedule_headers csh
5743: where not exists (select null
5744: from chv_schedule_items csi
5745: where csh.schedule_id = csi.schedule_id );
5746:
5747: COMMIT;
5748:

Line 5836: -- Update chv_schedule_items

5832: IF g_debug_switch in ('y','Y') THEN
5833: Print('(Purge_Schedules_by_Org)'||debug_info);
5834: END IF;
5835:
5836: -- Update chv_schedule_items
5837:
5838: update chv_schedule_items csi
5839: set csi.item_purge_status = 'PURGED'
5840: where exists

Line 5838: update chv_schedule_items csi

5834: END IF;
5835:
5836: -- Update chv_schedule_items
5837:
5838: update chv_schedule_items csi
5839: set csi.item_purge_status = 'PURGED'
5840: where exists
5841: (select null
5842: from chv_purge_schedule_list cpsl

Line 5919: delete from chv_schedule_items csi

5915:
5916: /* bug2067536 Performance Bug
5917: */
5918:
5919: delete from chv_schedule_items csi
5920: where not exists (select null
5921: from chv_schedule_items cs
5922: where csi.schedule_id = cs.schedule_id
5923: and nvl(cs.item_purge_status,'ACTIVE') <> 'PURGED');

Line 5921: from chv_schedule_items cs

5917: */
5918:
5919: delete from chv_schedule_items csi
5920: where not exists (select null
5921: from chv_schedule_items cs
5922: where csi.schedule_id = cs.schedule_id
5923: and nvl(cs.item_purge_status,'ACTIVE') <> 'PURGED');
5924:
5925: /* bug2067536 Performance Bug

Line 5930: from chv_schedule_items csi

5926: */
5927:
5928: delete from chv_schedule_headers csh
5929: where not exists (select null
5930: from chv_schedule_items csi
5931: where csh.schedule_id = csi.schedule_id );
5932:
5933: COMMIT;
5934:

Line 6520: chv_schedule_items = nvl(chv_schedule_items,0) - chv_item_rows,

6516: chv_cum_periods = nvl(chv_cum_periods,0) - chv_cum_rows,
6517: chv_horizontal_Schedules = nvl(chv_horizontal_schedules,0) - chv_hor_rows,
6518: chv_item_orders = nvl(chv_item_orders,0) - chv_ord_rows,
6519: chv_schedule_headers = nvl(chv_schedule_headers,0) - chv_head_rows,
6520: chv_schedule_items = nvl(chv_schedule_items,0) - chv_item_rows,
6521: ap_ae_lines = nvl(ap_ae_lines,0) - ae_line_rows,
6522: ap_ae_headers = nvl(ap_ae_headers,0) - ae_header_rows,
6523: ap_accounting_events = nvl(ap_accounting_events,0) - accounting_event_rows
6524: WHERE purge_name = p_purge_name;