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_INVOICES

Line 97: ap_invoices_all AI,

93: , AATD.awt_related_id
94: , aatd.checkrun_id
95: , TC.description --Bug5502917
96: FROM ap_awt_temp_distributions_all AATD,
97: ap_invoices_all AI,
98: ap_tax_codes_all TC,
99: ap_invoice_distributions_all AID --bug 7930936
100: WHERE AATD.invoice_id = InvId
101: AND AATD.group_id = GRP_ID

Line 139: FROM ap_invoices_all AI,

135: , AI.vat_code
136: , NVL(PV.federal_reportable_flag, 'N') federal_reportable_flag
137: , AI.vendor_site_id vendor_site_id
138: , AI.amount_applicable_to_discount
139: FROM ap_invoices_all AI,
140: po_vendors PV
141: WHERE PV.vendor_id(+) = DECODE(AI.invoice_type_lookup_code,'PAYMENT REQUEST', NULL, AI.vendor_id) --bug8272564
142: AND AI.invoice_id = InvId
143: FOR UPDATE of AI.invoice_id;

Line 156: ap_invoices_all AI,

152: , SUM(AATD.withholding_amount) AMOUNT
153: , SUM(AATD.base_withholding_amount) BASE_AMOUNT
154: , MIN(AATD.accounting_date) ACCOUNTING_DATE
155: FROM ap_awt_temp_distributions_all AATD,
156: ap_invoices_all AI,
157: ap_tax_codes_all TC,
158: ap_invoice_distributions_all AID --bug 7930936
159: WHERE AATD.invoice_id = InvId
160: AND AATD.invoice_id = AI.invoice_id

Line 275: ap_invoices_all ai

271: l_income_tax_region_flag,
272: l_income_tax_region_asp,
273: l_basecur
274: FROM ap_system_parameters_all asp,
275: ap_invoices_all ai
276: WHERE ai.org_id = asp.org_id
277: and ai.invoice_id = p_invoice_id;
278:
279: --bug 7930936

Line 1003: FROM AP_Invoices_All AI

999: from discount (if we opted the option exclude the freight from disc) */
1000: BEGIN
1001: SELECT AI.Exclude_Freight_From_Discount
1002: INTO l_exclude_freight_from_disc
1003: FROM AP_Invoices_All AI
1004: WHERE AI.Invoice_ID = P_Invoice_Id;
1005:
1006: debug_info := 'l_exclude_freight_from_disc ' || l_exclude_freight_from_disc;
1007: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1244: debug_info := 'Update ap_invoices';

1240: CLOSE c_payment_sched;
1241: END Update_Payment_Schedules;
1242:
1243: <>
1244: debug_info := 'Update ap_invoices';
1245: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1246: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
1247: END IF;
1248:

Line 1249: UPDATE ap_invoices_all

1245: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1246: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
1247: END IF;
1248:
1249: UPDATE ap_invoices_all
1250: SET awt_flag = DECODE(P_Create_dists, 'APPROVAL', 'Y','BOTH','Y', NULL), --Bug6660355
1251: amount_applicable_to_discount = decode (sign(invoice_amount),
1252: -1, amount_applicable_to_discount,
1253: amount_applicable_to_discount

Line 1298: new_invoice_id ap_invoices.invoice_id%TYPE;

1294: P_Dist_Line_No IN NUMBER DEFAULT NULL,
1295: P_New_Invoice_Id IN NUMBER DEFAULT NULL,
1296: P_create_dists IN VARCHAR2 DEFAULT NULL) --Bug7685907 bug8207324 bug8236169
1297: IS
1298: new_invoice_id ap_invoices.invoice_id%TYPE;
1299: tax_authority_id ap_tax_codes.awt_vendor_id%TYPE;
1300: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;
1301: base_currency ap_system_parameters.base_currency_code%TYPE;
1302: new_invoice_base_descr ap_invoices.description%TYPE;

Line 1302: new_invoice_base_descr ap_invoices.description%TYPE;

1298: new_invoice_id ap_invoices.invoice_id%TYPE;
1299: tax_authority_id ap_tax_codes.awt_vendor_id%TYPE;
1300: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;
1301: base_currency ap_system_parameters.base_currency_code%TYPE;
1302: new_invoice_base_descr ap_invoices.description%TYPE;
1303: inv_terms_date DATE;
1304: ta_terms_id po_vendor_sites.terms_id%TYPE;
1305: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
1306: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;

Line 1310: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;

1306: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
1307: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
1308: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
1309: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
1310: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
1311: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1312: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1313: l_legal_entity_id ap_invoices_all.legal_entity_id%type;
1314:

Line 1311: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;

1307: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
1308: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
1309: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
1310: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
1311: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1312: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1313: l_legal_entity_id ap_invoices_all.legal_entity_id%type;
1314:
1315: l_set_of_books_id ap_invoices_all.set_of_books_id%type;

Line 1313: l_legal_entity_id ap_invoices_all.legal_entity_id%type;

1309: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
1310: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
1311: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1312: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1313: l_legal_entity_id ap_invoices_all.legal_entity_id%type;
1314:
1315: l_set_of_books_id ap_invoices_all.set_of_books_id%type;
1316: l_batch_id ap_invoices_all.batch_id%type;
1317: l_org_id ap_invoices_all.org_id%type;

Line 1315: l_set_of_books_id ap_invoices_all.set_of_books_id%type;

1311: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1312: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1313: l_legal_entity_id ap_invoices_all.legal_entity_id%type;
1314:
1315: l_set_of_books_id ap_invoices_all.set_of_books_id%type;
1316: l_batch_id ap_invoices_all.batch_id%type;
1317: l_org_id ap_invoices_all.org_id%type;
1318: l_period_name gl_period_statuses.period_name%type;
1319:

Line 1316: l_batch_id ap_invoices_all.batch_id%type;

1312: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1313: l_legal_entity_id ap_invoices_all.legal_entity_id%type;
1314:
1315: l_set_of_books_id ap_invoices_all.set_of_books_id%type;
1316: l_batch_id ap_invoices_all.batch_id%type;
1317: l_org_id ap_invoices_all.org_id%type;
1318: l_period_name gl_period_statuses.period_name%type;
1319:
1320: l_line_number ap_invoice_lines_all.line_number%type;

Line 1317: l_org_id ap_invoices_all.org_id%type;

1313: l_legal_entity_id ap_invoices_all.legal_entity_id%type;
1314:
1315: l_set_of_books_id ap_invoices_all.set_of_books_id%type;
1316: l_batch_id ap_invoices_all.batch_id%type;
1317: l_org_id ap_invoices_all.org_id%type;
1318: l_period_name gl_period_statuses.period_name%type;
1319:
1320: l_line_number ap_invoice_lines_all.line_number%type;
1321: l_dist_number ap_invoice_distributions_all.distribution_line_number%type;

Line 1379: ap_invoices_all AI

1375: , APID.awt_related_id awt_related_id -- bug 9913164
1376: FROM ap_invoice_distributions_all APID,
1377: ap_invoice_distributions_all APID1,
1378: ap_tax_codes_all ATC,
1379: ap_invoices_all AI
1380: WHERE (APID.invoice_id = InvId)
1381: AND (APID.invoice_line_number = NVL(P_Inv_Line_No,line_num))
1382: AND (APID.distribution_line_number = NVL(P_dist_Line_No,APID.distribution_line_number))
1383: AND (APID.line_type_lookup_code = 'AWT')

Line 1429: ap_invoices_all AI

1425: , APID.awt_related_id awt_related_id -- bug 9913164
1426: FROM ap_invoice_distributions_all APID,
1427: ap_invoice_distributions_all APID1,
1428: ap_tax_codes_all ATC,
1429: ap_invoices_all AI
1430: WHERE (APID.invoice_id = InvId)
1431: AND (APID.invoice_line_number = NVL(P_Inv_Line_No,line_num))
1432: AND (APID.distribution_line_number = NVL(P_dist_Line_No,APID.distribution_line_number))
1433: AND (APID.line_type_lookup_code = 'AWT')

Line 1471: AP_INVOICES_ALL AI

1467: , APID.invoice_line_number
1468: FROM ap_invoice_distributions_all APID,
1469: ap_invoice_distributions_all APID1,
1470: ap_tax_codes_all ATC,
1471: AP_INVOICES_ALL AI
1472: WHERE (APID.invoice_id = InvId)
1473: AND (APID.line_type_lookup_code = 'AWT')
1474: AND (NVL(APID.awt_flag , 'M' ) = 'A' )
1475: AND APID.WITHHOLDING_TAX_CODE_ID = ATC.tax_id

Line 1508: AP_INVOICES_ALL AI

1504: , APID.invoice_line_number
1505: FROM ap_invoice_distributions_all APID,
1506: ap_invoice_distributions_all APID1,
1507: ap_tax_codes_all ATC,
1508: AP_INVOICES_ALL AI
1509: WHERE (APID.invoice_id = InvId)
1510: AND (APID.line_type_lookup_code = 'AWT')
1511: AND (NVL(APID.awt_flag , 'M' ) = 'A' )
1512: AND APID.WITHHOLDING_TAX_CODE_ID = ATC.tax_id

Line 1557: , ap_invoices_all i

1553: i.set_of_books_id,
1554: i.batch_id,
1555: i.org_id
1556: FROM po_vendors v
1557: , ap_invoices_all i
1558: WHERE (v.vendor_id = i.vendor_id)
1559: AND (i.invoice_id = InvId);
1560:
1561: DBG_Loc VARCHAR2(30) := 'Create_AWT_Invoices';

Line 1607: --ap_invoices_all and ap_invoice_lines_all

1603:
1604:
1605: --Bug 8266021 inv cursor called based on calling module
1606: --This cursor will fetch info required to insert into
1607: --ap_invoices_all and ap_invoice_lines_all
1608: debug_info := 'OPEN CURSOR c_awt_invs';
1609:
1610: IF (P_Calling_Module in ('CANCEL INVOICE','REVERSE DIST','VOID PAYMENT')) THEN
1611: OPEN c_awt_invs_rev (P_Invoice_Id);

Line 1660: NVL(P_New_Invoice_Id, ap_invoices_s.nextval),

1656: IS
1657: SELECT t.awt_vendor_id,
1658: t.awt_vendor_site_id,
1659: NVL(s.payment_currency_code, s.invoice_currency_code),
1660: NVL(P_New_Invoice_Id, ap_invoices_s.nextval),
1661: p.base_currency_code,
1662: s.terms_id,
1663: s.payment_priority,
1664: s.terms_date_basis,

Line 1759: ap_invoices_pkg.get_payment_attributes(

1755:
1756: --4610924, added this call to get payment attributes
1757: -- Added nvl conditions for p_payee_party_id, p_payee_party_site_id, p_supplier_site_id
1758: -- as part of bug 8345877
1759: ap_invoices_pkg.get_payment_attributes(
1760: p_le_id =>l_legal_entity_id,
1761: p_org_id =>l_org_id, --bug 10072576
1762: p_payee_party_id => nvl(l_remit_party_id, l_party_id), --bug 7721149, replacing l_party_id for Third Party Payments
1763: p_payee_party_site_id => nvl(l_remit_to_party_site_id, l_party_site_id), --bug 7721149, replacing l_party_site_id for Third Party Payments

Line 1821: FROM ap_invoices_all

1817: SELECT invoice_received_date,
1818: goods_received_date
1819: INTO invoice_received_date,
1820: goods_received_date
1821: FROM ap_invoices_all
1822: WHERE invoice_id = P_Invoice_Id;
1823: END IF;
1824:
1825: --added for bug 8266021 to fetch period

Line 1842: debug_info := 'Insert Into ap_invoices';

1838: AND Nvl(Asp.Org_Id,- 99) = Nvl(l_org_id,- 99);
1839: -- AND gps.closing_Status in ('O', 'F');
1840: --bug 9304565 commented the above condition as part of this bug.
1841:
1842: debug_info := 'Insert Into ap_invoices';
1843: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1844: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
1845: END IF;
1846:

Line 1847: INSERT INTO ap_invoices_all

1843: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1844: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
1845: END IF;
1846:
1847: INSERT INTO ap_invoices_all
1848: (invoice_id
1849: ,last_UPDATE_date
1850: ,last_UPDATEd_by
1851: ,vendor_id

Line 1994: (p_table_name => 'AP_INVOICES',

1990: );
1991:
1992: --Bug 4539462 DBI logging
1993: AP_DBI_PKG.Maintain_DBI_Summary
1994: (p_table_name => 'AP_INVOICES',
1995: p_operation => 'I',
1996: p_key_value1 => new_invoice_id,
1997: p_calling_sequence => current_calling_sequence);
1998:

Line 2463: l_awt_flag ap_invoices.awt_flag%TYPE;

2459: P_Invoice_Payment_Id IN NUMBER DEFAULT NULL,
2460: P_Check_Id IN NUMBER DEFAULT NULL,
2461: p_checkrun_id in number default null)
2462: IS
2463: l_awt_flag ap_invoices.awt_flag%TYPE;
2464: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
2465: l_tax_name ap_tax_codes.name%TYPE;
2466: l_payment_date DATE := p_awt_date;
2467: l_org_id number; --4742265

Line 2464: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;

2460: P_Check_Id IN NUMBER DEFAULT NULL,
2461: p_checkrun_id in number default null)
2462: IS
2463: l_awt_flag ap_invoices.awt_flag%TYPE;
2464: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
2465: l_tax_name ap_tax_codes.name%TYPE;
2466: l_payment_date DATE := p_awt_date;
2467: l_org_id number; --4742265
2468:

Line 2759: ap_invoices_all ai

2755: l_awt_flag,
2756: l_inv_curr_code,
2757: l_org_id --4742265
2758: FROM ap_system_parameters_all asp,
2759: ap_invoices_all ai
2760: WHERE ai.org_id = asp.org_id
2761: and ai.invoice_id = p_invoice_id;
2762:
2763: --Bug6660355

Line 3043: ap_invoices_all AI,

3039: , NVL(asp.awt_include_discount_amt, 'N') include_discount_amt
3040: , asp.base_currency_code
3041: , NVL(ASI.payment_exchange_rate,1) payment_exchange_rate --bug 8590059
3042: FROM ap_SELECTed_invoices_all ASI,
3043: ap_invoices_all AI,
3044: ap_system_parameters_all asp
3045: WHERE ASI.checkrun_name = l_checkrun_name
3046: AND asi.checkrun_id = l_checkrun_id
3047: AND AI.invoice_id = ASI.invoice_id

Line 3057: FROM ap_invoices AI

3053: AND AID.line_type_lookup_code = 'AWT'
3054: AND AID.awt_flag = 'M')
3055: AND ((ASP.create_awt_dists_type ='PAYMENT' --Bug6660355
3056: AND NOT EXISTS (SELECT 'Invoice already withheld by AutoApproval'
3057: FROM ap_invoices AI
3058: WHERE AI.invoice_id = ASI.invoice_id
3059: AND NVL(AI.awt_flag, 'N') = 'Y'))
3060: OR
3061: ASP.create_awt_dists_type ='BOTH')

Line 3172: FROM ap_invoice_distributions aid,ap_invoices ai

3168:
3169: --Bug6660355
3170: /*SELECT sum(nvl(aid.base_amount,aid.amount)) --query is commented for Bug:14696775
3171: INTO l_total_awt_amount
3172: FROM ap_invoice_distributions aid,ap_invoices ai
3173: WHERE aid.invoice_id = ai.invoice_id
3174: AND aid.invoice_id =rec_ok_sel_invs.invoice_id
3175: AND aid.line_type_lookup_code in ('AWT')
3176: AND aid.awt_origin_group_id = ai.awt_group_id;*/

Line 3551: , ap_invoices_all AI

3547: SELECT ASI.invoice_id
3548: , ASI.payment_num
3549: , AI.vendor_id
3550: FROM ap_SELECTed_invoices_all ASI
3551: , ap_invoices_all AI
3552: WHERE ASI.checkrun_name = l_checkrun_name
3553: AND AI.invoice_id = ASI.invoice_id
3554: and asi.checkrun_id = l_checkrun_id;
3555:

Line 3563: , ap_invoices_all AI

3559: SELECT ASI.invoice_id
3560: , ASI.payment_num
3561: , AI.vendor_id
3562: FROM ap_SELECTed_invoices_all ASI
3563: , ap_invoices_all AI
3564: , iby_fd_docs_payable_v ibydocs
3565: WHERE ASI.checkrun_name = p_checkrun_name
3566: AND AI.invoice_id = ASI.invoice_id
3567: and asi.checkrun_id = p_checkrun_id

Line 3736: ap_invoices_all AI,

3732: , AATD.tax_rate_id
3733: , TC.tax_id tax_code_id
3734: , aatd.checkrun_id
3735: FROM ap_awt_temp_distributions_all AATD,
3736: ap_invoices_all AI,
3737: ap_tax_codes_all TC
3738: WHERE AATD.invoice_id = InvId
3739: AND AATD.invoice_id = AI.invoice_id
3740: AND TC.name(+) = AATD.tax_name

Line 3775: ap_invoices_all AI,

3771: , TC.tax_id tax_code_id
3772: , aatd.checkrun_id
3773: , AATD.accounting_date
3774: FROM ap_awt_temp_distributions_all AATD,
3775: ap_invoices_all AI,
3776: ap_tax_codes_all TC
3777: WHERE AATD.invoice_id = InvId
3778: AND AATD.invoice_id = AI.invoice_id
3779: AND TC.name(+) = AATD.tax_name

Line 4390: --,ap_invoices AI --Bug8547506

4386: , AID.global_attribute20
4387: /* End of fix for bug#8462050*/
4388: FROM ap_invoice_distributions AID,
4389: ap_tax_codes TC
4390: --,ap_invoices AI --Bug8547506
4391: WHERE AID.invoice_id = ParentId
4392: AND TC.tax_id (+) = AID.withholding_tax_code_id /* Bug 5382525 */
4393: --Bug8547506 Undoing changes done for bug6660355
4394: --AND AID.invoice_id = AI.invoice_id --6660355

Line 4582: --,ap_invoices AI --Bug8547506

4578: , AID.awt_gross_amount
4579: /* End of fix for bug#8462050*/
4580: FROM ap_invoice_distributions AID,
4581: ap_tax_codes TC
4582: --,ap_invoices AI --Bug8547506
4583: WHERE AID.invoice_id = ParentId
4584: AND TC.tax_id (+) = AID.withholding_tax_code_id
4585: AND AID.invoice_line_number = NVL(P_Inv_Line_No,
4586: AID.invoice_line_number)

Line 4593: l_invoice_exchange_rate ap_invoices.exchange_rate%type;

4589:
4590: rec_awt_gross_dists c_awt_gross_dists_pay%ROWTYPE;
4591: --Bug12594549
4592:
4593: l_invoice_exchange_rate ap_invoices.exchange_rate%type;
4594: l_func_currency_code ap_system_parameters.base_currency_code%TYPE;
4595: l_old_inv_line_num ap_invoice_lines_all.line_number%TYPE;
4596:
4597: l_pay_awt_invs_count NUMBER; /* Bug 10353952 */

Line 4643: FROM AP_INVOICES_ALL AI

4639:
4640: IF (P_Calling_Module in ('CANCEL INVOICE','REVERSE DIST')) THEN
4641: SELECT AI.org_id
4642: INTO l_org_id
4643: FROM AP_INVOICES_ALL AI
4644: WHERE invoice_id = P_Parent_Id;
4645:
4646: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN
4647: SELECT AIP.org_id

Line 4770: FROM ap_invoices

4766: SELECT vendor_id
4767: , set_of_books_id
4768: , exchange_date
4769: , exchange_rate
4770: FROM ap_invoices
4771: WHERE invoice_id = InvId
4772: FOR UPDATE;
4773: rec_invoice c_invoice%ROWTYPE;
4774:

Line 4826: FROM ap_invoices ai, ap_invoice_payments aip

4822: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN
4823:
4824: SELECT ai.exchange_rate
4825: INTO l_invoice_exchange_rate
4826: FROM ap_invoices ai, ap_invoice_payments aip
4827: WHERE ai.invoice_id = aip.invoice_id
4828: AND aip.invoice_payment_id =rec_awt_gross_dists.awt_invoice_payment_id;
4829:
4830: END IF;

Line 4988: FROM ap_invoices

4984: , exchange_rate_type
4985: -- , ussgl_transaction_code - Bug 4277744
4986: -- , ussgl_trx_code_context - Bug 4277744
4987: , vat_code
4988: FROM ap_invoices
4989: WHERE invoice_id = InvId
4990: FOR UPDATE;
4991: rec_invoice c_invoice%ROWTYPE;
4992:

Line 5267: ap_invoices AI

5263: , NVL(APS.inv_curr_gross_amount, APS.gross_Amount) inv_curr_gross_amount
5264: , APS.amount_remaining
5265: , AI.payment_currency_code
5266: FROM ap_payment_schedules APS,
5267: ap_invoices AI
5268: WHERE AI.invoice_id = InvId
5269: AND AI.invoice_id = APS.invoice_id
5270: AND APS.payment_num = NVL(PaymNum, APS.payment_num) /* Bug 5300858 */
5271: FOR UPDATE of APS.gross_amount, APS.inv_curr_gross_amount, APS.amount_remaining;

Line 5344: UPDATE ap_invoices

5340: rec_payment_sched.payment_currency_code),gross_amount,'N','P')
5341: WHERE CURRENT of c_payment_sched;
5342:
5343: -- Bug 8300099/7518063 : Added below update statement
5344: UPDATE ap_invoices
5345: SET payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status( rec_awt_dists.invoice_id )
5346: WHERE invoice_id = rec_awt_dists.invoice_id ;
5347:
5348: ELSE

Line 5345: SET payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status( rec_awt_dists.invoice_id )

5341: WHERE CURRENT of c_payment_sched;
5342:
5343: -- Bug 8300099/7518063 : Added below update statement
5344: UPDATE ap_invoices
5345: SET payment_status_flag = AP_INVOICES_UTILITY_PKG.get_payment_status( rec_awt_dists.invoice_id )
5346: WHERE invoice_id = rec_awt_dists.invoice_id ;
5347:
5348: ELSE
5349: NULL;

Line 5404: FROM ap_invoices ai, ap_invoice_payments aip

5400: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN
5401:
5402: SELECT ai.exchange_rate
5403: INTO l_invoice_exchange_rate
5404: FROM ap_invoices ai, ap_invoice_payments aip
5405: WHERE ai.invoice_id = aip.invoice_id
5406: AND aip.invoice_payment_id = rec_awt_dists.awt_invoice_payment_id;
5407: END IF;
5408:

Line 5725: ap_invoices_all AI

5721: ,PaymNum IN NUMBER)
5722: is
5723: select ai.vendor_id, aatd.accounting_date, aatd.tax_name, aatd.withholding_amount
5724: from ap_awt_temp_distributions_all AATD,
5725: ap_invoices_all AI
5726: where aatd.invoice_id = InvId
5727: and AATD.invoice_id = AI.invoice_id
5728: AND ( PaymNum IS NULL
5729: OR AATD.payment_num = PaymNum)

Line 5741: ap_invoices_all AI

5737: ,PaymNum IN NUMBER)
5738: is
5739: select ai.vendor_id, aatd.accounting_date, aatd.tax_name, aatd.gross_amount
5740: from ap_awt_temp_distributions_all AATD,
5741: ap_invoices_all AI
5742: where aatd.invoice_id = InvId
5743: and AATD.invoice_id = AI.invoice_id
5744: AND ( PaymNum IS NULL
5745: OR AATD.payment_num = PaymNum)