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_WITHHOLDING_PKG dependencies on AP_SELECTED_INVOICES_ALL

Line 1925: FROM ap_SELECTed_invoices_all ASI,

1921: IS
1922: SELECT invoice_id
1923: , vendor_id
1924: , payment_num
1925: FROM ap_SELECTed_invoices_all ASI,
1926: ap_system_parameters_all asp
1927: WHERE checkrun_name = l_checkrun_name
1928: AND original_invoice_id IS NULL
1929: AND asp.org_id = asi.org_id

Line 1979: UPDATE ap_SELECTed_invoices_all

1975:
1976: -- DO Withholding for all OK to pay SELECTed invoices in thIS checkrun
1977: -- that have No Manual AWT dists
1978:
1979: UPDATE ap_SELECTed_invoices_all
1980: SET ok_to_pay_flag = 'Y',
1981: proposed_payment_amount = invoice_amount * payment_cross_rate,
1982: -- We cannot round the proposed_payment_amount here since we don't
1983: -- have payment_currency_code. We will round it later.

Line 2006: FROM ap_SELECTed_invoices_all ASI,

2002: , NVL(ASI.payment_cross_rate,1) payment_cross_rate
2003: , AI.payment_currency_code
2004: , NVL(asp.awt_include_discount_amt, 'N') include_discount_amt
2005: , asp.base_currency_code
2006: FROM ap_SELECTed_invoices_all ASI,
2007: ap_invoices_all AI,
2008: ap_system_parameters_all asp
2009: WHERE ASI.checkrun_name = l_checkrun_name
2010: AND asi.checkrun_id = l_checkrun_id

Line 2108: FROM ap_selected_invoices_all

2104: END IF;
2105:
2106: SELECT invoice_amount, amount_remaining
2107: INTO l_invoice_amount, l_amount_remaining
2108: FROM ap_selected_invoices_all
2109: WHERE invoice_id = rec_ok_sel_invs.invoice_id
2110: AND checkrun_name = p_checkrun_name
2111: and checkrun_id = p_checkrun_id
2112: AND payment_num = rec_ok_sel_invs.payment_num;

Line 2128: FROM ap_SELECTed_invoices_all

2124:
2125: SELECT SUM(NVL(payment_amount,0)) +
2126: SUM((-1) * NVL(withholding_amount,0))
2127: INTO l_total_amount
2128: FROM ap_SELECTed_invoices_all
2129: WHERE checkrun_name = p_checkrun_name
2130: and checkrun_id = p_checkrun_id
2131: AND NVL(ok_to_pay_flag,'Y') in ( 'Y','F');
2132:

Line 2136: FROM ap_selected_invoices_all

2132:
2133: --Get the count of credit AND debit memos in the batch.
2134: Select COUNT(*)
2135: INTO l_count
2136: FROM ap_selected_invoices_all
2137: WHERE checkrun_name = p_checkrun_name
2138: and checkrun_id = p_checkrun_id
2139: AND NVL(ok_to_pay_flag,'Y') IN ( 'Y','F')
2140: AND invoice_amount < 0;

Line 2154: FROM ap_selected_invoices_all

2150:
2151: SELECT (-1) * (SUM(NVL(payment_amount,0) +
2152: NVL(ABS(withholding_amount),0)))
2153: INTO l_subject_amount
2154: FROM ap_selected_invoices_all
2155: WHERE payment_amount > 0
2156: AND NVL(ok_to_pay_flag,'Y') in ( 'Y','F')
2157: AND checkrun_name = p_checkrun_name
2158: and checkrun_id = p_checkrun_id;

Line 2167: FROM ap_selected_invoices_all

2163: IF l_count > 1 THEN
2164: SELECT (-1) * (SUM(NVL(ABS(payment_amount),0) +
2165: NVL(withholding_amount,0)))
2166: INTO l_amountapplied
2167: FROM ap_selected_invoices_all
2168: WHERE NVL(withholding_amount,0) > 0
2169: AND NVL(ok_to_pay_flag,'Y') in ( 'Y','F')
2170: AND checkrun_name = p_checkrun_name
2171: and checkrun_id = p_checkrun_id;

Line 2234: UPDATE ap_selected_invoices_all ASI

2230: rec_ok_sel_invs.payment_currency_code);
2231:
2232: debug_info := 'Update proposed payment in ap_selected_invoices';
2233:
2234: UPDATE ap_selected_invoices_all ASI
2235: SET ASI.proposed_payment_amount =
2236: ap_utilities_pkg.ap_round_currency(
2237: ASI.proposed_payment_amount,rec_ok_sel_invs.payment_currency_code) -
2238: l_withholding_amount

Line 2249: UPDATE ap_SELECTed_invoices_all ASI

2245: WHERE current of c_ok_sel_invs;
2246: ELSE
2247: debug_info := 'Update AWT error in ap_selected_invoices';
2248:
2249: UPDATE ap_SELECTed_invoices_all ASI
2250: SET ASI.ok_to_pay_flag = 'N',
2251: ASI.dont_pay_reason_code = 'AWT ERROR',
2252: ASI.dont_pay_description = substr(l_awt_success, 1, 255)
2253: WHERE current of c_ok_sel_invs;

Line 2311: FROM ap_selected_invoices_all ASI,

2307: CURSOR c_ok_sel_invs IS
2308: SELECT ASI.invoice_id,
2309: ASI.payment_num,
2310: p_check_date payment_date
2311: FROM ap_selected_invoices_all ASI,
2312: iby_fd_docs_payable_v ibydocs
2313: WHERE ASI.checkrun_name = p_checkrun_name
2314: AND ASI.original_invoice_id IS NULL
2315: and asi.checkrun_id = p_checkrun_id

Line 2418: FROM ap_SELECTed_invoices_all ASI

2414: IS
2415: SELECT ASI.invoice_id
2416: , ASI.payment_num
2417: , AI.vendor_id
2418: FROM ap_SELECTed_invoices_all ASI
2419: , ap_invoices_all AI
2420: WHERE ASI.checkrun_name = l_checkrun_name
2421: AND AI.invoice_id = ASI.invoice_id
2422: and asi.checkrun_id = l_checkrun_id;

Line 2430: FROM ap_SELECTed_invoices_all ASI

2426: CURSOR C_sel_invs is
2427: SELECT ASI.invoice_id
2428: , ASI.payment_num
2429: , AI.vendor_id
2430: FROM ap_SELECTed_invoices_all ASI
2431: , ap_invoices_all AI
2432: , iby_fd_docs_payable_v ibydocs
2433: WHERE ASI.checkrun_name = p_checkrun_name
2434: AND AI.invoice_id = ASI.invoice_id

Line 2697: FROM ap_SELECTed_invoices_all ASI

2693: l_checkrun_id in number) IS
2694: SELECT ASI.payment_currency_code,
2695: ASI.invoice_exchange_rate,
2696: ASI.payment_cross_rate
2697: FROM ap_SELECTed_invoices_all ASI
2698: WHERE ASI.checkrun_name = l_checkrun_name
2699: AND ASI.invoice_id = l_invoice_id
2700: AND ASI.payment_num = l_payment_num
2701: and asi.checkrun_id = l_checkrun_id;

Line 2726: UPDATE ap_SELECTed_invoices_all

2722: curr_code.payment_currency_code);
2723: END ;
2724:
2725: debug_info := 'Update ap SELECTed invoices';
2726: UPDATE ap_SELECTed_invoices_all
2727: SET payment_amount = payment_amount +
2728: NVL(l_withholding_amount,0),
2729: proposed_payment_amount = proposed_payment_amount +
2730: NVL(l_withholding_amount,0),