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

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 339: ap_invoice_distributions aid

335: IS
336: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
337: FROM ap_invoices ai,
338: ap_invoice_lines ail,
339: ap_invoice_distributions aid
340: WHERE ai.vendor_id = cv_vendor_id
341: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
342: AND ai.payment_status_flag = 'Y'
343: AND NVL(ai.earliest_settlement_date,sysdate+1) <= SYSDATE

Line 793: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

789: -- there is no need to verify the payment_status flag.
790:
791: SELECT SUM(NVL(aid.amount,0))
792: INTO l_invoice_amount_remaining
793: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
794: WHERE ail.invoice_id = p_invoice_id
795: AND ail.invoice_id = aid.invoice_id
796: AND ail.line_number = aid.invoice_line_number
797: --Contract Payments: Although Recoupment is modelled as 'PREPAY' dists

Line 820: ap_invoice_distributions_all aid

816: -- Get the Prepay Amount Remaining
817: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
818: INTO l_prepay_amount_remaining
819: FROM ap_invoice_lines_all ail,
820: ap_invoice_distributions_all aid
821: WHERE ail.invoice_id = p_prepay_invoice_id
822: AND ail.line_number = p_prepay_line_num
823: AND ail.line_type_lookup_code = 'ITEM'
824: AND NVL(ail.discarded_flag,'N') <> 'Y'

Line 858: ap_invoice_distributions_all aid

854: -- Get the Prepay Amount Remaining
855: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
856: INTO l_prepay_amount_remaining
857: FROM ap_invoice_lines_all ail,
858: ap_invoice_distributions_all aid
859: WHERE ail.invoice_id = p_prepay_invoice_id
860: AND ail.line_type_lookup_code = 'ITEM'
861: AND NVL(ail.discarded_flag,'N') <> 'Y'
862: AND NVL(ail.line_selected_for_appl_flag, 'N') <> 'Y'

Line 896: ap_invoice_distributions aid

892: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
893: INTO l_prepay_amount_remaining
894: FROM ap_invoices ai,
895: ap_invoice_lines ail,
896: ap_invoice_distributions aid
897: WHERE ai.vendor_id = p_vendor_id
898: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
899: AND nvl(ai.earliest_settlement_date,sysdate+1) <= SYSDATE
900: AND ai.payment_status_flag = 'Y'

Line 1472: ap_invoice_distributions_all.distribution_line_number%TYPE;

1468:
1469: -- PREPAY distributions related variables
1470: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
1471: l_max_dist_number
1472: ap_invoice_distributions_all.distribution_line_number%TYPE;
1473: l_loop_counter BINARY_INTEGER := 1;
1474: l_loop_variable BINARY_INTEGER;
1475: l_dist_line_counter NUMBER := 1;
1476: l_prepay_dist_s_quant_invoiced

Line 1477: ap_invoice_distributions_all.quantity_invoiced%TYPE;

1473: l_loop_counter BINARY_INTEGER := 1;
1474: l_loop_variable BINARY_INTEGER;
1475: l_dist_line_counter NUMBER := 1;
1476: l_prepay_dist_s_quant_invoiced
1477: ap_invoice_distributions_all.quantity_invoiced%TYPE;
1478: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;
1479: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;
1480:
1481: l_debug_info VARCHAR2(4000);

Line 1478: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;

1474: l_loop_variable BINARY_INTEGER;
1475: l_dist_line_counter NUMBER := 1;
1476: l_prepay_dist_s_quant_invoiced
1477: ap_invoice_distributions_all.quantity_invoiced%TYPE;
1478: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;
1479: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;
1480:
1481: l_debug_info VARCHAR2(4000);
1482: l_current_calling_sequence VARCHAR2(2000);

Line 1479: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;

1475: l_dist_line_counter NUMBER := 1;
1476: l_prepay_dist_s_quant_invoiced
1477: ap_invoice_distributions_all.quantity_invoiced%TYPE;
1478: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;
1479: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;
1480:
1481: l_debug_info VARCHAR2(4000);
1482: l_current_calling_sequence VARCHAR2(2000);
1483:

Line 1591: FROM ap_invoice_distributions

1587: p_gl_date,
1588: p_period_name,
1589: global_attribute_category,
1590: 'PREPAY' line_type_lookup_code
1591: FROM ap_invoice_distributions
1592: WHERE invoice_id = CV_PPAY_Invoice_ID
1593: AND invoice_line_number = CV_PPAY_LINE_NUM
1594: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL')
1595: AND NVL(prepay_amount_remaining,total_dist_amount) > 0

Line 1622: FROM ap_invoice_distributions

1618: decode(line_type_lookup_code,'NONREC_TAX',charge_applicable_to_dist_id,
1619: 'REC_TAX',charge_applicable_to_dist_id,NULL) parent_chrg_appl_to_dist_id,
1620: decode(line_type_lookup_code,'TERV',related_id, 'TIPV', related_id,
1621: 'TRV',related_id, NULL) parent_related_id
1622: FROM ap_invoice_distributions
1623: WHERE invoice_id = CV_PPAY_Invoice_ID
1624: AND invoice_line_number = CV_PPAY_LINE_NUM
1625: AND line_type_lookup_code IN ('ITEM','ACCRUAL')
1626: AND NVL(prepay_amount_remaining,total_dist_amount) > 0

Line 2061: FROM ap_invoice_distributions

2057: IF (P_calling_mode = 'PREPAYMENT APPLICATION') THEN
2058:
2059: SELECT NVL(MAX(distribution_line_number),0)
2060: INTO l_max_dist_number
2061: FROM ap_invoice_distributions
2062: WHERE invoice_id = p_invoice_id
2063: AND invoice_line_number = l_prepay_ln_number;
2064:
2065: --For Recoupment, 'PREPAY' distributions are tied to the ITEM line itself.

Line 2070: FROM ap_invoice_distributions

2066: ELSIF (P_calling_mode = 'RECOUPMENT') THEN
2067:
2068: SELECT NVL(MAX(distribution_line_number),0)
2069: INTO l_max_dist_number
2070: FROM ap_invoice_distributions
2071: WHERE invoice_id = p_invoice_id
2072: AND invoice_line_number = p_invoice_line_number ;
2073:
2074: END IF;

Line 2327: FROM ap_invoice_distributions

2323: NVL( ABS(SUM(pa_quantity)), 0 )
2324: INTO l_prepay_dist_s_quant_invoiced,
2325: l_prepay_dist_s_stat_amount,
2326: l_prepay_dist_s_pa_quantity
2327: FROM ap_invoice_distributions
2328: WHERE prepay_distribution_id =
2329: l_prepay_dist_info(l_loop_variable).PREPAY_DISTRIBUTION_ID;
2330:
2331: IF (l_prepay_dist_info(l_loop_variable).PPAY_PO_DISTRIBUTION_ID IS NOT NULL

Line 2489: FROM ap_invoice_distributions_all aid

2485: BEGIN
2486:
2487: SELECT SUM(NVL(aid.prepay_tax_diff_amount, 0))
2488: INTO l_prepay_tax_diff_amt
2489: FROM ap_invoice_distributions_all aid
2490: WHERE aid.invoice_id = p_invoice_id
2491: AND aid.invoice_line_number = l_prepay_ln_number
2492: AND aid.line_type_lookup_code = 'NONREC_TAX'
2493: AND NVL(aid.reversal_flag,'N') <> 'Y';

Line 2629: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

2625: -- ==========================================================
2626: --Bug5224883
2627: -- Get the exculusive tax amount for the prepay appln line.
2628: SELECT sum(aid.amount) into l_prepay_excl_tax_amt
2629: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
2630: WHERE ail.line_type_lookup_code='TAX'
2631: AND ail.invoice_id=p_invoice_id
2632: and aid.invoice_id=ail.invoice_id
2633: AND aid.invoice_line_number=ail.line_number

Line 2635: AND exists( select 1 from ap_invoice_distributions_all aid1

2631: AND ail.invoice_id=p_invoice_id
2632: and aid.invoice_id=ail.invoice_id
2633: AND aid.invoice_line_number=ail.line_number
2634: AND ail.prepay_line_number is not null
2635: AND exists( select 1 from ap_invoice_distributions_all aid1
2636: where aid1.invoice_id=p_invoice_id
2637: and aid1.invoice_line_number=l_prepay_ln_number
2638: and aid1.invoice_distribution_id=aid.charge_applicable_to_dist_id);
2639: -- Bug 5307022. Added the NVL for amount calculation in case of non exclusive tax

Line 3229: l_global_attr_category ap_invoice_distributions_all.global_attribute_category%TYPE;

3225: RETURN BOOLEAN IS
3226:
3227: l_loop_counter BINARY_INTEGER;
3228: l_invoice_distribution_id NUMBER;
3229: l_global_attr_category ap_invoice_distributions_all.global_attribute_category%TYPE;
3230: l_result BOOLEAN;
3231: l_debug_info VARCHAR2(100);
3232: l_calling_sequence VARCHAR2(2000);
3233: l_calling_program VARCHAR2(1000);

Line 3261: SELECT ap_invoice_distributions_s.NEXTVAL

3257: AND line_number=p_line_number;
3258:
3259: FOR l_loop_counter IN nvl(p_prepay_dist_info.first,0) .. nvl(p_prepay_dist_info.last,0) LOOP
3260:
3261: SELECT ap_invoice_distributions_s.NEXTVAL
3262: INTO p_prepay_dist_info(l_loop_counter).invoice_distribution_id
3263: FROM sys.dual; -- Check if it's better to use sequence.CURRVAL instead of dual.
3264:
3265:

Line 3286: FROM ap_invoice_distributions

3282: END IF;
3283:
3284: SELECT invoice_distribution_id
3285: INTO p_prepay_dist_info(l_loop_counter).charge_applicable_to_dist_id
3286: FROM ap_invoice_distributions
3287: WHERE invoice_id = p_invoice_id
3288: AND invoice_line_number = p_line_number
3289: AND line_type_lookup_code = 'PREPAY'
3290: and prepay_distribution_id = p_prepay_dist_info(l_loop_counter).parent_chrg_appl_to_dist_id;

Line 3302: FROM ap_invoice_distributions

3298:
3299:
3300: SELECT invoice_distribution_id
3301: INTO p_prepay_dist_info(l_loop_counter).related_id
3302: FROM ap_invoice_distributions
3303: WHERE invoice_id = p_invoice_id
3304: AND invoice_line_number = p_line_number
3305: AND line_type_lookup_code in ('NONREC_TAX','REC_TAX')
3306: AND prepay_distribution_id = p_prepay_dist_info(l_loop_counter).parent_related_id;

Line 3312: l_debug_info := 'Insert into ap_invoice_distributions';

3308: END IF;
3309:
3310: END IF;
3311:
3312: l_debug_info := 'Insert into ap_invoice_distributions';
3313: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3314: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3315: END IF;
3316:

Line 3325: INSERT INTO AP_INVOICE_DISTRIBUTIONS

3321: END IF;
3322:
3323:
3324:
3325: INSERT INTO AP_INVOICE_DISTRIBUTIONS
3326: (ACCOUNTING_DATE,
3327: ACCRUAL_POSTED_FLAG,
3328: ASSETS_ADDITION_FLAG,
3329: ASSETS_TRACKING_FLAG,

Line 3687: FROM ap_invoice_distributions

3683: INTENDED_USE,
3684: 'N',
3685: l_invoice_includes_prepay_flag, --Bug5224996
3686: ORG_ID
3687: FROM ap_invoice_distributions
3688: WHERE invoice_distribution_id = p_prepay_dist_info(l_loop_counter).PREPAY_DISTRIBUTION_ID;
3689:
3690: -- ===============================================================
3691: -- Call GMS

Line 3802: FROM ap_invoice_distributions_all

3798:
3799: CURSOR C_Update_Prepayments IS
3800: SELECT prepay_distribution_id,
3801: ABS(amount)
3802: FROM ap_invoice_distributions_all
3803: WHERE invoice_id = p_invoice_id
3804: AND invoice_line_number = p_invoice_line_num
3805: AND NVL(reversal_flag,'N') = 'Y'
3806: AND parent_reversal_id IS NOT NULL;

Line 3838: UPDATE ap_invoice_distributions

3834: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3835: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3836: END IF;
3837:
3838: UPDATE ap_invoice_distributions
3839: SET prepay_amount_remaining =
3840: NVL(prepay_amount_remaining, total_dist_amount) -
3841: p_prepay_dist_info(l_loop_counter).PREPAY_APPLY_AMOUNT
3842: WHERE invoice_distribution_id =

Line 3870: UPDATE ap_invoice_distributions_all dp

3866: -- we will not maintain the prepay_amount_Remaining at that level.
3867:
3868: -- Exclusive Tax Distributions
3869: BEGIN
3870: UPDATE ap_invoice_distributions_all dp
3871: SET dp.prepay_amount_remaining =
3872: (SELECT SUM(NVL(dp.prepay_amount_remaining, dp.total_dist_amount) +
3873: (NVL(ds.amount, 0) + NVL(ds.prepay_tax_diff_amount, 0)))
3874: FROM ap_invoice_distributions_all ds

Line 3874: FROM ap_invoice_distributions_all ds

3870: UPDATE ap_invoice_distributions_all dp
3871: SET dp.prepay_amount_remaining =
3872: (SELECT SUM(NVL(dp.prepay_amount_remaining, dp.total_dist_amount) +
3873: (NVL(ds.amount, 0) + NVL(ds.prepay_tax_diff_amount, 0)))
3874: FROM ap_invoice_distributions_all ds
3875: WHERE ds.prepay_distribution_id = dp.invoice_distribution_id)
3876: WHERE dp.invoice_id = p_prepay_invoice_id
3877: AND dp.line_type_lookup_code IN ('REC_TAX','NONREC_TAX')
3878: AND exists (select 'Exclusive Prepay Tax Line'

Line 3891: UPDATE ap_invoice_distributions_all dp

3887: END;
3888:
3889: -- Inclusive Tax Distributions
3890: BEGIN
3891: UPDATE ap_invoice_distributions_all dp
3892: SET dp.prepay_amount_remaining = NVL(dp.prepay_amount_remaining, dp.total_dist_amount) + /*Bug 7372625*/
3893: (SELECT SUM(/*NVL(dp.prepay_amount_remaining, dp.total_dist_amount) +*/
3894: (NVL(ds.amount, 0) + NVL(ds.prepay_tax_diff_amount, 0)))
3895: FROM ap_invoice_distributions_all ds

Line 3895: FROM ap_invoice_distributions_all ds

3891: UPDATE ap_invoice_distributions_all dp
3892: SET dp.prepay_amount_remaining = NVL(dp.prepay_amount_remaining, dp.total_dist_amount) + /*Bug 7372625*/
3893: (SELECT SUM(/*NVL(dp.prepay_amount_remaining, dp.total_dist_amount) +*/
3894: (NVL(ds.amount, 0) + NVL(ds.prepay_tax_diff_amount, 0)))
3895: FROM ap_invoice_distributions_all ds
3896: WHERE ds.prepay_distribution_id = dp.invoice_distribution_id)
3897: WHERE dp.invoice_id = p_prepay_invoice_id
3898: AND dp.invoice_line_number = p_prepay_line_num
3899: AND dp.line_type_lookup_code IN ('REC_TAX','NONREC_TAX');

Line 3936: UPDATE ap_invoice_distributions

3932:
3933:
3934: EXIT WHEN C_Update_Prepayments%NOTFOUND;
3935:
3936: UPDATE ap_invoice_distributions
3937: SET prepay_amount_remaining = prepay_amount_remaining +
3938: l_apply_amount
3939: WHERE invoice_distribution_id = l_prepay_distribution_id;
3940:

Line 4029: FROM ap_invoice_distributions aid,

4025: aid.po_distribution_id,
4026: aid.amount,
4027: aid.quantity_invoiced,
4028: plt.matching_basis
4029: FROM ap_invoice_distributions aid,
4030: ap_invoice_lines ail,
4031: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
4032: po_line_locations pll,
4033: po_line_types_b plt, --bug 5056269