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_PREPAY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 241: ap_invoice_distributions_all aid

237: cv_prepay_line_num NUMBER)
238: IS
239: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
240: FROM ap_invoice_lines_all ail,
241: ap_invoice_distributions_all aid
242: WHERE ail.invoice_id = cv_prepay_invoice_id
243: AND ail.line_number = cv_prepay_line_num
244: AND NVL(ail.line_selected_for_appl_flag,'N') <> 'Y'
245: AND aid.invoice_id = ail.invoice_id

Line 290: ap_invoice_distributions_all aid

286: (cv_prepay_invoice_id NUMBER)
287: IS
288: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
289: FROM ap_invoice_lines_all ail,
290: ap_invoice_distributions_all aid
291: WHERE ail.invoice_id = cv_prepay_invoice_id
292: AND ail.line_type_lookup_code <> 'TAX'
293: AND NVL(ail.line_selected_for_appl_flag,'N') <> 'Y'
294: AND aid.invoice_id = ail.invoice_id

Line 794: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

790:
791: /* Start of fix for bug8692604 */
792: /* SELECT SUM(NVL(aid.amount,0))
793: INTO l_invoice_amount_remaining
794: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
795: WHERE ail.invoice_id = p_invoice_id
796: AND ail.invoice_id = aid.invoice_id
797: AND ail.line_number = aid.invoice_line_number
798: --Contract Payments: Although Recoupment is modelled as 'PREPAY' dists

Line 828: ap_invoice_distributions_all aid

824: -- Get the Prepay Amount Remaining
825: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
826: INTO l_prepay_amount_remaining
827: FROM ap_invoice_lines_all ail,
828: ap_invoice_distributions_all aid
829: WHERE ail.invoice_id = p_prepay_invoice_id
830: AND ail.line_number = p_prepay_line_num
831: AND ail.line_type_lookup_code = 'ITEM'
832: AND NVL(ail.discarded_flag,'N') <> 'Y'

Line 866: ap_invoice_distributions_all aid

862: -- Get the Prepay Amount Remaining
863: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
864: INTO l_prepay_amount_remaining
865: FROM ap_invoice_lines_all ail,
866: ap_invoice_distributions_all aid
867: WHERE ail.invoice_id = p_prepay_invoice_id
868: AND ail.line_type_lookup_code = 'ITEM'
869: AND NVL(ail.discarded_flag,'N') <> 'Y'
870: AND NVL(ail.line_selected_for_appl_flag, 'N') <> 'Y'

Line 1494: ap_invoice_distributions_all.distribution_line_number%TYPE;

1490:
1491: -- PREPAY distributions related variables
1492: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
1493: l_max_dist_number
1494: ap_invoice_distributions_all.distribution_line_number%TYPE;
1495: l_loop_counter BINARY_INTEGER := 1;
1496: l_loop_variable BINARY_INTEGER;
1497: l_dist_line_counter NUMBER := 1;
1498: l_prepay_dist_s_quant_invoiced

Line 1499: ap_invoice_distributions_all.quantity_invoiced%TYPE;

1495: l_loop_counter BINARY_INTEGER := 1;
1496: l_loop_variable BINARY_INTEGER;
1497: l_dist_line_counter NUMBER := 1;
1498: l_prepay_dist_s_quant_invoiced
1499: ap_invoice_distributions_all.quantity_invoiced%TYPE;
1500: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;
1501: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;
1502:
1503: l_debug_info VARCHAR2(4000);

Line 1500: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;

1496: l_loop_variable BINARY_INTEGER;
1497: l_dist_line_counter NUMBER := 1;
1498: l_prepay_dist_s_quant_invoiced
1499: ap_invoice_distributions_all.quantity_invoiced%TYPE;
1500: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;
1501: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;
1502:
1503: l_debug_info VARCHAR2(4000);
1504: l_current_calling_sequence VARCHAR2(2000);

Line 1501: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;

1497: l_dist_line_counter NUMBER := 1;
1498: l_prepay_dist_s_quant_invoiced
1499: ap_invoice_distributions_all.quantity_invoiced%TYPE;
1500: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;
1501: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;
1502:
1503: l_debug_info VARCHAR2(4000);
1504: l_current_calling_sequence VARCHAR2(2000);
1505:

Line 2735: FROM ap_invoice_distributions_all aid

2731: BEGIN
2732:
2733: SELECT SUM(NVL(aid.prepay_tax_diff_amount, 0))
2734: INTO l_prepay_tax_diff_amt
2735: FROM ap_invoice_distributions_all aid
2736: WHERE aid.invoice_id = p_invoice_id
2737: AND aid.invoice_line_number = l_prepay_ln_number
2738: AND aid.line_type_lookup_code = 'NONREC_TAX'
2739: AND NVL(aid.reversal_flag,'N') <> 'Y';

Line 2892: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

2888: -- ==========================================================
2889: --Bug5224883
2890: -- Get the exculusive tax amount for the prepay appln line.
2891: SELECT sum(aid.amount) into l_prepay_excl_tax_amt
2892: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
2893: WHERE ail.line_type_lookup_code='TAX'
2894: AND ail.invoice_id=p_invoice_id
2895: and aid.invoice_id=ail.invoice_id
2896: AND aid.invoice_line_number=ail.line_number

Line 2898: AND exists( select 1 from ap_invoice_distributions_all aid1

2894: AND ail.invoice_id=p_invoice_id
2895: and aid.invoice_id=ail.invoice_id
2896: AND aid.invoice_line_number=ail.line_number
2897: AND ail.prepay_line_number is not null
2898: AND exists( select 1 from ap_invoice_distributions_all aid1
2899: where aid1.invoice_id=p_invoice_id
2900: and aid1.invoice_line_number=l_prepay_ln_number
2901: and aid1.invoice_distribution_id=aid.charge_applicable_to_dist_id);
2902: -- Bug 5307022. Added the NVL for amount calculation in case of non exclusive tax

Line 3515: l_global_attr_category ap_invoice_distributions_all.global_attribute_category%TYPE;

3511: RETURN BOOLEAN IS
3512:
3513: l_loop_counter BINARY_INTEGER;
3514: l_invoice_distribution_id NUMBER;
3515: l_global_attr_category ap_invoice_distributions_all.global_attribute_category%TYPE;
3516: l_result BOOLEAN;
3517: l_debug_info VARCHAR2(4000); --Changed length from 100 to 4000 (8534097)
3518: l_calling_sequence VARCHAR2(2000);
3519: l_calling_program VARCHAR2(1000);

Line 4095: UPDATE ap_invoice_distributions_all dp

4091: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4092: END IF;
4093:
4094: -- 7338249
4095: UPDATE ap_invoice_distributions_all dp
4096: SET dp.prepay_amount_remaining = dp.total_dist_amount +
4097: (SELECT SUM(
4098: (NVL(ds.amount, 0) + NVL(ds.prepay_tax_diff_amount, 0)))
4099: FROM ap_invoice_distributions_all ds

Line 4099: FROM ap_invoice_distributions_all ds

4095: UPDATE ap_invoice_distributions_all dp
4096: SET dp.prepay_amount_remaining = dp.total_dist_amount +
4097: (SELECT SUM(
4098: (NVL(ds.amount, 0) + NVL(ds.prepay_tax_diff_amount, 0)))
4099: FROM ap_invoice_distributions_all ds
4100: WHERE ds.prepay_distribution_id = dp.invoice_distribution_id),
4101: dp.last_updated_by = FND_GLOBAL.user_id, /*Bug10101705: Added who columns*/
4102: dp.last_update_date = SYSDATE,/*Bug10101705: Added who columns*/
4103: dp.last_update_login = FND_GLOBAL.login_id /*Bug10101705: Added who columns*/