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.IGC_CC_ARCHIVE_PURGE_PKG dependencies on PO_HEADERS

Line 2099: INTO igc_cc_arc_po_headers_all

2095: -- Archive the appropriate PO tables that contain the information on
2096: -- the CC Headers that have already been archived.
2097: -- --------------------------------------------------------------------
2098: INSERT
2099: INTO igc_cc_arc_po_headers_all
2100: (po_header_id,
2101: agent_id,
2102: type_lookup_code,
2103: last_update_date,

Line 2353: FROM po_headers PHA

2349: mrc_rate,
2350: pcard_id,
2351: price_update_tolerance,
2352: pay_on_code
2353: FROM po_headers PHA
2354: -- ssmales 11/07/03 bug 2885953 - amended where clause below for performance issues
2355: -- WHERE PHA.po_header_id IN
2356: -- ( SELECT PHA1.po_header_id
2357: -- FROM po_headers_all PHA1

Line 2357: -- FROM po_headers_all PHA1

2353: FROM po_headers PHA
2354: -- ssmales 11/07/03 bug 2885953 - amended where clause below for performance issues
2355: -- WHERE PHA.po_header_id IN
2356: -- ( SELECT PHA1.po_header_id
2357: -- FROM po_headers_all PHA1
2358: -- WHERE PHA1.segment1 IN
2359: WHERE PHA.segment1 IN
2360: ( SELECT ICV.cc_num
2361: FROM igc_arc_pur_candidates ICV

Line 2367: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into PO Headers ALL Table for ' ||

2363: -- );
2364:
2365: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
2366: IF (g_debug_mode = 'Y') THEN
2367: g_debug_msg := ' Inserted ' || SQL%ROWCOUNT || ' number rows into PO Headers ALL Table for ' ||
2368: ' Last Activity Date : ' || g_last_activity_date;
2369: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2370: END IF;
2371:

Line 2598: FROM po_headers PHA

2594: tax_code_id
2595: FROM po_lines PLA
2596: WHERE PLA.po_header_id IN
2597: ( SELECT PHA.po_header_id
2598: FROM po_headers PHA
2599: WHERE PHA.segment1 IN
2600: ( SELECT ICV.cc_num
2601: FROM igc_arc_pur_candidates ICV
2602: )

Line 2862: FROM po_headers PHA

2858: change_promised_date_reason
2859: FROM po_line_locations PLLA
2860: WHERE PLLA.po_header_id IN
2861: ( SELECT po_header_id
2862: FROM po_headers PHA
2863: WHERE PHA.segment1 IN
2864: ( SELECT ICV.cc_num
2865: FROM igc_arc_pur_candidates ICV
2866: )

Line 3064: FROM po_headers PHA

3060: recovery_rate
3061: FROM po_distributions PDA
3062: WHERE PDA.po_header_id IN
3063: ( SELECT po_header_id
3064: FROM po_headers PHA
3065: WHERE PHA.segment1 IN
3066: ( SELECT ICV.cc_num
3067: FROM igc_arc_pur_candidates ICV
3068: )

Line 3190: po_headers_all PHA1,

3186: AND trunc (ICCCHV.max_dt) <= trunc (g_last_activity_date)
3187: AND ICH.cc_header_id NOT IN
3188: ( SELECT ICH1.cc_header_id
3189: FROM igc_cc_headers ICH1,
3190: po_headers_all PHA1,
3191: po_distributions_all PDA,
3192: ap_invoice_distributions_all AIDA,
3193: ap_invoices_all AIA1
3194: WHERE /*ICH1.set_of_books_id = g_sob_id

Line 3854: g_debug_msg := ' Deleting records from Archive PO Headers table for' ||

3850: -- Delete Archived PO Header records that may exist
3851: -- --------------------------------------------------------------------
3852: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3853: IF (g_debug_mode = 'Y') THEN
3854: g_debug_msg := ' Deleting records from Archive PO Headers table for' ||
3855: ' Last Activity Date : ' || g_last_activity_date;
3856: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3857: END IF;
3858:

Line 3860: FROM igc_cc_arc_po_headers IPHA

3856: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3857: END IF;
3858:
3859: DELETE
3860: FROM igc_cc_arc_po_headers IPHA
3861: WHERE IPHA.po_header_id IN
3862: ( SELECT PHA1.po_header_id
3863: FROM po_headers_all PHA1
3864: WHERE PHA1.segment1 IN

Line 3863: FROM po_headers_all PHA1

3859: DELETE
3860: FROM igc_cc_arc_po_headers IPHA
3861: WHERE IPHA.po_header_id IN
3862: ( SELECT PHA1.po_header_id
3863: FROM po_headers_all PHA1
3864: WHERE PHA1.segment1 IN
3865: ( SELECT ICV.cc_num
3866: FROM igc_arc_pur_candidates ICV
3867: )

Line 3884: FROM po_headers_all PHA

3880: DELETE
3881: FROM igc_cc_arc_po_lines IPLA
3882: WHERE IPLA.po_header_id IN
3883: ( SELECT PHA.po_header_id
3884: FROM po_headers_all PHA
3885: WHERE PHA.segment1 IN
3886: ( SELECT ICV.cc_num
3887: FROM igc_arc_pur_candidates ICV
3888: )

Line 3905: FROM po_headers_all PHA

3901: DELETE
3902: FROM igc_cc_arc_po_line_loc IPLLA
3903: WHERE IPLLA.po_header_id IN
3904: ( SELECT PHA.po_header_id
3905: FROM po_headers_all PHA
3906: WHERE PHA.segment1 IN
3907: ( SELECT ICV.cc_num
3908: FROM igc_arc_pur_candidates ICV
3909: )

Line 3926: FROM po_headers_all PHA

3922: DELETE
3923: FROM igc_cc_arc_po_distribution IPDA
3924: WHERE IPDA.po_header_id IN
3925: ( SELECT PHA.po_header_id
3926: FROM po_headers_all PHA
3927: WHERE PHA.segment1 IN
3928: ( SELECT ICV.cc_num
3929: FROM igc_arc_pur_candidates ICV
3930: )

Line 5280: FROM po_headers_all PHA

5276: DELETE
5277: FROM po_distributions_all PDA
5278: WHERE PDA.po_header_id IN
5279: ( SELECT PHA.po_header_id
5280: FROM po_headers_all PHA
5281: WHERE PHA.segment1 IN
5282: ( SELECT ICV.cc_num
5283: FROM igc_arc_pur_candidates ICV
5284: WHERE ICV.cc_header_id = l_cc_header_id

Line 5302: FROM po_headers_all PHA

5298: DELETE
5299: FROM po_line_locations_all PLLA
5300: WHERE PLLA.po_header_id IN
5301: ( SELECT PHA.po_header_id
5302: FROM po_headers_all PHA
5303: WHERE PHA.segment1 IN
5304: ( SELECT ICV.cc_num
5305: FROM igc_arc_pur_candidates ICV
5306: WHERE ICV.cc_header_id = l_cc_header_id

Line 5324: FROM po_headers_all PHA

5320: DELETE
5321: FROM po_lines_all PLA
5322: WHERE PLA.po_header_id IN
5323: ( SELECT PHA.po_header_id
5324: FROM po_headers_all PHA
5325: WHERE PHA.segment1 IN
5326: ( SELECT ICV.cc_num
5327: FROM igc_arc_pur_candidates ICV
5328: WHERE ICV.cc_header_id = l_cc_header_id

Line 5343: FROM po_headers_all PHA

5339: -- --------------------------------------------------------------------
5340: -- Delete all PO Header records for related CC Header IDs.
5341: -- --------------------------------------------------------------------
5342: DELETE
5343: FROM po_headers_all PHA
5344: WHERE PHA.po_header_id IN
5345: ( SELECT PHA1.po_header_id
5346: FROM po_headers_all PHA1
5347: WHERE PHA1.segment1 IN

Line 5346: FROM po_headers_all PHA1

5342: DELETE
5343: FROM po_headers_all PHA
5344: WHERE PHA.po_header_id IN
5345: ( SELECT PHA1.po_header_id
5346: FROM po_headers_all PHA1
5347: WHERE PHA1.segment1 IN
5348: ( SELECT ICV.cc_num
5349: FROM igc_arc_pur_candidates ICV
5350: WHERE ICV.cc_header_id = l_cc_header_id

Line 5355: g_debug_msg := 'Number Rows Deleted from PO_HEADERS_ALL for CC Header ID : ' ||

5351: )
5352: );
5353:
5354: IF (g_debug_mode = 'Y') THEN
5355: g_debug_msg := 'Number Rows Deleted from PO_HEADERS_ALL for CC Header ID : ' ||
5356: l_cc_header_id || ' SOB ID : ' || g_sob_id || ' is : ' ||
5357: to_char(SQL%ROWCOUNT);
5358: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5359: END IF;