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

900: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
901: INTO l_prepay_amount_remaining
902: FROM ap_invoices ai,
903: ap_invoice_lines ail,
904: ap_invoice_distributions aid
905: WHERE ai.vendor_id = p_vendor_id
906: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
907: AND nvl(ai.earliest_settlement_date,sysdate+1) <= SYSDATE
908: AND ai.payment_status_flag = '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 1618: FROM ap_invoice_distributions

1614: p_gl_date,
1615: p_period_name,
1616: global_attribute_category,
1617: 'PREPAY' line_type_lookup_code
1618: FROM ap_invoice_distributions
1619: WHERE invoice_id = CV_PPAY_Invoice_ID
1620: AND invoice_line_number = CV_PPAY_LINE_NUM
1621: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL')
1622: AND NVL(prepay_amount_remaining,total_dist_amount) > 0

Line 1650: FROM ap_invoice_distributions

1646: decode(line_type_lookup_code,'NONREC_TAX',charge_applicable_to_dist_id,
1647: 'REC_TAX',charge_applicable_to_dist_id,NULL) parent_chrg_appl_to_dist_id,
1648: decode(line_type_lookup_code,'TERV',related_id, 'TIPV', related_id,
1649: 'TRV',related_id, NULL) parent_related_id
1650: FROM ap_invoice_distributions
1651: WHERE invoice_id = CV_PPAY_Invoice_ID
1652: AND invoice_line_number = CV_PPAY_LINE_NUM
1653: AND line_type_lookup_code IN ('ITEM','ACCRUAL')
1654: AND NVL(prepay_amount_remaining,total_dist_amount) > 0

Line 2149: FROM ap_invoice_distributions

2145: IF (P_calling_mode = 'PREPAYMENT APPLICATION') THEN
2146:
2147: SELECT NVL(MAX(distribution_line_number),0)
2148: INTO l_max_dist_number
2149: FROM ap_invoice_distributions
2150: WHERE invoice_id = p_invoice_id
2151: AND invoice_line_number = l_prepay_ln_number;
2152:
2153: --For Recoupment, 'PREPAY' distributions are tied to the ITEM line itself.

Line 2158: FROM ap_invoice_distributions

2154: ELSIF (P_calling_mode = 'RECOUPMENT') THEN
2155:
2156: SELECT NVL(MAX(distribution_line_number),0)
2157: INTO l_max_dist_number
2158: FROM ap_invoice_distributions
2159: WHERE invoice_id = p_invoice_id
2160: AND invoice_line_number = p_invoice_line_number ;
2161:
2162: END IF;

Line 2558: FROM ap_invoice_distributions

2554: NVL( ABS(SUM(pa_quantity)), 0 )
2555: INTO l_prepay_dist_s_quant_invoiced,
2556: l_prepay_dist_s_stat_amount,
2557: l_prepay_dist_s_pa_quantity
2558: FROM ap_invoice_distributions
2559: WHERE prepay_distribution_id =
2560: l_prepay_dist_info(l_loop_variable).PREPAY_DISTRIBUTION_ID;
2561:
2562: IF (l_prepay_dist_info(l_loop_variable).PPAY_PO_DISTRIBUTION_ID IS NOT NULL

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 3547: SELECT ap_invoice_distributions_s.NEXTVAL

3543: AND line_number=p_line_number;
3544:
3545: FOR l_loop_counter IN nvl(p_prepay_dist_info.first,0) .. nvl(p_prepay_dist_info.last,0) LOOP
3546:
3547: SELECT ap_invoice_distributions_s.NEXTVAL
3548: INTO p_prepay_dist_info(l_loop_counter).invoice_distribution_id
3549: FROM sys.dual; -- Check if it's better to use sequence.CURRVAL instead of dual.
3550:
3551:

Line 3572: FROM ap_invoice_distributions

3568: END IF;
3569:
3570: SELECT invoice_distribution_id
3571: INTO p_prepay_dist_info(l_loop_counter).charge_applicable_to_dist_id
3572: FROM ap_invoice_distributions
3573: WHERE invoice_id = p_invoice_id
3574: AND invoice_line_number = p_line_number
3575: AND line_type_lookup_code = 'PREPAY'
3576: and prepay_distribution_id = p_prepay_dist_info(l_loop_counter).parent_chrg_appl_to_dist_id;

Line 3588: FROM ap_invoice_distributions

3584:
3585:
3586: SELECT invoice_distribution_id
3587: INTO p_prepay_dist_info(l_loop_counter).related_id
3588: FROM ap_invoice_distributions
3589: WHERE invoice_id = p_invoice_id
3590: AND invoice_line_number = p_line_number
3591: AND line_type_lookup_code in ('NONREC_TAX','REC_TAX')
3592: AND prepay_distribution_id = p_prepay_dist_info(l_loop_counter).parent_related_id;

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

3594: END IF;
3595:
3596: END IF;
3597:
3598: l_debug_info := 'Insert into ap_invoice_distributions';
3599: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3600: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3601: END IF;
3602:

Line 3611: INSERT INTO AP_INVOICE_DISTRIBUTIONS

3607: END IF;
3608:
3609:
3610:
3611: INSERT INTO AP_INVOICE_DISTRIBUTIONS
3612: (ACCOUNTING_DATE,
3613: ACCRUAL_POSTED_FLAG,
3614: ASSETS_ADDITION_FLAG,
3615: ASSETS_TRACKING_FLAG,

Line 3971: FROM ap_invoice_distributions

3967: 'N',
3968: l_invoice_includes_prepay_flag, --Bug5224996
3969: ORG_ID,
3970: PAY_AWT_GROUP_ID --Bug 9058369
3971: FROM ap_invoice_distributions
3972: WHERE invoice_distribution_id = p_prepay_dist_info(l_loop_counter).PREPAY_DISTRIBUTION_ID;
3973:
3974: -- ===============================================================
3975: -- Call GMS

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*/

Line 4195: FROM ap_invoice_distributions aid,

4191: aid.po_distribution_id,
4192: aid.amount,
4193: aid.quantity_invoiced,
4194: plt.matching_basis
4195: FROM ap_invoice_distributions aid,
4196: ap_invoice_lines ail,
4197: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
4198: po_line_locations pll,
4199: po_line_types_b plt, --bug 5056269