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 360: chv_schedule_items csi,

356:
357: delete from chv_purge_schedule_list cpsl
358: where exists (select null
359: from chv_cum_periods ccp,
360: chv_schedule_items csi,
361: chv_schedule_headers csh,
362: chv_org_options coo
363: where ccp.organization_id = g_organization_id
364: and sysdate between ccp.cum_period_start_date and

Line 410: from chv_schedule_items csi,

406: -- test_chv_in_edi
407:
408: delete from chv_purge_schedule_list cpsl
409: where exists (select null
410: from chv_schedule_items csi,
411: ece_spso_items esi
412: where csi.schedule_item_id = cpsl.schedule_item_id
413: and csi.schedule_id = esi.schedule_id);
414:

Line 1473: from chv_schedule_items csi,

1469: double_check_flag)
1470: select csi.schedule_item_id,
1471: p_purge_name,
1472: 'Y'
1473: from chv_schedule_items csi,
1474: chv_schedule_headers csh,
1475: chv_purge_cum_list cpcl,
1476: chv_cum_periods ccp
1477: where csh.schedule_id = csi.schedule_id

Line 1526: from chv_schedule_items csi,

1522: double_check_flag)
1523: select csi.schedule_item_id,
1524: p_purge_name,
1525: 'Y'
1526: from chv_schedule_items csi,
1527: chv_schedule_headers csh
1528: where csh.schedule_id = csi.schedule_id
1529: and csh.last_update_date <= g_activity_date
1530: and NVL(csi.item_purge_status,'N') <> 'PURGED'

Line 2616: from chv_schedule_items csi,

2612: select MAX('Y')
2613: into range_inserted
2614: from sys.dual
2615: where exists (select null
2616: from chv_schedule_items csi,
2617: chv_schedule_headers csh,
2618: chv_history_schedules chs
2619: where csi.item_id = chs.item_id
2620: and csi.schedule_id = chs.schedule_id

Line 2670: chv_schedule_items csi

2666: csi.organization_id,
2667: p_purge_name
2668: from chv_purge_schedule_list cpsl,
2669: chv_schedule_headers csh,
2670: chv_schedule_items csi
2671: where cpsl.schedule_item_id = csi.schedule_item_id
2672: and csi.schedule_id = csh.schedule_id
2673: and cpsl.double_check_flag = 'Y'
2674: and cpsl.schedule_item_id between range_low and range_high;

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

4176:
4177: update chv_purge_schedule_list cpsl
4178: set double_check_flag = 'N'
4179: where cpsl.double_check_flag = 'Y'
4180: and not exists (select 'schedule not purgeable' from chv_schedule_items csi,
4181: chv_schedule_headers csh
4182: where csh.schedule_id = csi.schedule_id
4183: and csh.last_update_date <= g_activity_date
4184: and csi.organization_id = g_organization_id

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

4237:
4238: update chv_purge_schedule_list cpsl
4239: set double_check_flag = 'N'
4240: where cpsl.double_check_flag = 'Y'
4241: and not exists (select null from chv_schedule_items csi,
4242: chv_schedule_headers csh,
4243: chv_cum_periods ccp,
4244: chv_purge_cum_list cpcl
4245: where csh.schedule_id = csi.schedule_id

Line 4292: chv_schedule_items csi,

4288: set double_check_flag = 'N'
4289: where cpsl.double_check_flag = 'Y'
4290: and exists (select null
4291: from chv_cum_periods ccp,
4292: chv_schedule_items csi,
4293: chv_schedule_headers csh,
4294: chv_org_options coo
4295: where ccp.organization_id = g_organization_id
4296: and sysdate between ccp.cum_period_start_date and

Line 4343: from chv_schedule_items csi,

4339: update chv_purge_schedule_list cpsl
4340: set double_check_flag = 'N'
4341: where cpsl.double_check_flag = 'Y'
4342: and exists (select null
4343: from chv_schedule_items csi,
4344: ece_spso_items esi
4345: where csi.schedule_item_id = cpsl.schedule_item_id
4346: and csi.schedule_id = esi.schedule_id);
4347:

Line 4467: FROM chv_schedule_items

4463:
4464: --
4465: SELECT count(*)
4466: INTO chv_item_rows
4467: FROM chv_schedule_items
4468: WHERE NVL(item_purge_status,'N') <> 'PURGED';
4469:
4470: RETURN (TRUE);
4471:

Line 4547: chv_schedule_items = fp_chv_item_rows,

4543: chv_cum_periods = fp_chv_cum_rows,
4544: chv_horizontal_schedules = fp_chv_hor_rows,
4545: chv_item_orders = fp_chv_ord_rows,
4546: chv_schedule_headers = fp_chv_head_rows,
4547: chv_schedule_items = fp_chv_item_rows,
4548: ap_ae_lines = fp_ae_line_rows,
4549: ap_ae_headers = fp_ae_header_rows,
4550: ap_accounting_events = fp_accounting_event_rows,
4551: ap_chrg_allocations = fp_chrg_allocation_rows,

Line 6157: -- Update chv_schedule_items

6153: IF g_debug_switch in ('y','Y') THEN
6154: Print('(Purge_Schedules_by_Cum)'||debug_info);
6155: END IF;
6156:
6157: -- Update chv_schedule_items
6158:
6159: update chv_schedule_items csi
6160: set csi.item_purge_status = 'PURGED'
6161: where exists

Line 6159: update chv_schedule_items csi

6155: END IF;
6156:
6157: -- Update chv_schedule_items
6158:
6159: update chv_schedule_items csi
6160: set csi.item_purge_status = 'PURGED'
6161: where exists
6162: (select null
6163: from chv_purge_schedule_list cpsl

Line 6278: debug_info := 'chv_schedule_items';

6274: from chv_purge_cum_list cpcl
6275: where cpcl.cum_period_id = ccp.cum_period_id
6276: and cpcl.double_check_flag = 'Y');
6277:
6278: debug_info := 'chv_schedule_items';
6279: IF g_debug_switch in ('y','Y') THEN
6280: Print('(Purge_Schedules_by_Cum)'||debug_info);
6281: END IF;
6282:

Line 6283: -- delete_chv_schedule_items

6279: IF g_debug_switch in ('y','Y') THEN
6280: Print('(Purge_Schedules_by_Cum)'||debug_info);
6281: END IF;
6282:
6283: -- delete_chv_schedule_items
6284:
6285: /* bug2067536 Performance Bug
6286: */
6287: delete from chv_schedule_items csi

Line 6287: delete from chv_schedule_items csi

6283: -- delete_chv_schedule_items
6284:
6285: /* bug2067536 Performance Bug
6286: */
6287: delete from chv_schedule_items csi
6288: where not exists (select null
6289: from chv_schedule_items cs
6290: where csi.schedule_id = cs.schedule_id
6291: and nvl(cs.item_purge_status,'ACTIVE') <> 'PURGED');

Line 6289: from chv_schedule_items cs

6285: /* bug2067536 Performance Bug
6286: */
6287: delete from chv_schedule_items csi
6288: where not exists (select null
6289: from chv_schedule_items cs
6290: where csi.schedule_id = cs.schedule_id
6291: and nvl(cs.item_purge_status,'ACTIVE') <> 'PURGED');
6292:
6293: debug_info := 'chv_schedule_headers';

Line 6304: from chv_schedule_items csi

6300: /* bug2067536 Performance Bug
6301: */
6302: delete from chv_schedule_headers csh
6303: where not exists (select null
6304: from chv_schedule_items csi
6305: where csh.schedule_id = csi.schedule_id );
6306:
6307: COMMIT;
6308:

Line 6396: -- Update chv_schedule_items

6392: IF g_debug_switch in ('y','Y') THEN
6393: Print('(Purge_Schedules_by_Org)'||debug_info);
6394: END IF;
6395:
6396: -- Update chv_schedule_items
6397:
6398: update chv_schedule_items csi
6399: set csi.item_purge_status = 'PURGED'
6400: where exists

Line 6398: update chv_schedule_items csi

6394: END IF;
6395:
6396: -- Update chv_schedule_items
6397:
6398: update chv_schedule_items csi
6399: set csi.item_purge_status = 'PURGED'
6400: where exists
6401: (select null
6402: from chv_purge_schedule_list cpsl

Line 6479: delete from chv_schedule_items csi

6475:
6476: /* bug2067536 Performance Bug
6477: */
6478:
6479: delete from chv_schedule_items csi
6480: where not exists (select null
6481: from chv_schedule_items cs
6482: where csi.schedule_id = cs.schedule_id
6483: and nvl(cs.item_purge_status,'ACTIVE') <> 'PURGED');

Line 6481: from chv_schedule_items cs

6477: */
6478:
6479: delete from chv_schedule_items csi
6480: where not exists (select null
6481: from chv_schedule_items cs
6482: where csi.schedule_id = cs.schedule_id
6483: and nvl(cs.item_purge_status,'ACTIVE') <> 'PURGED');
6484:
6485: /* bug2067536 Performance Bug

Line 6490: from chv_schedule_items csi

6486: */
6487:
6488: delete from chv_schedule_headers csh
6489: where not exists (select null
6490: from chv_schedule_items csi
6491: where csh.schedule_id = csi.schedule_id );
6492:
6493: COMMIT;
6494:

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

7206: chv_cum_periods = nvl(chv_cum_periods,0) - chv_cum_rows,
7207: chv_horizontal_Schedules = nvl(chv_horizontal_schedules,0) - chv_hor_rows,
7208: chv_item_orders = nvl(chv_item_orders,0) - chv_ord_rows,
7209: chv_schedule_headers = nvl(chv_schedule_headers,0) - chv_head_rows,
7210: chv_schedule_items = nvl(chv_schedule_items,0) - chv_item_rows,
7211: ap_ae_lines = nvl(ap_ae_lines,0) - ae_line_rows,
7212: ap_ae_headers = nvl(ap_ae_headers,0) - ae_header_rows,
7213: ap_accounting_events = nvl(ap_accounting_events,0) - accounting_event_rows
7214: WHERE purge_name = p_purge_name;