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 66: ap_invoices_all AI,

62: , AATD.awt_related_id
63: , aatd.checkrun_id
64: , TC.description --Bug5502917
65: FROM ap_awt_temp_distributions_all AATD,
66: ap_invoices_all AI,
67: ap_tax_codes_all TC
68: WHERE AATD.invoice_id = InvId
69: AND AATD.invoice_id = AI.invoice_id
70: AND AATD.tax_name = TC.name(+)

Line 103: FROM ap_invoices_all AI,

99: , AI.vat_code
100: , NVL(PV.federal_reportable_flag, 'N') federal_reportable_flag
101: , AI.vendor_site_id vendor_site_id
102: , AI.amount_applicable_to_discount
103: FROM ap_invoices_all AI,
104: po_vendors PV
105: WHERE PV.vendor_id = AI.vendor_id
106: AND AI.invoice_id = InvId
107: FOR UPDATE of AI.invoice_id;

Line 153: ap_invoices_all ai

149: l_income_tax_region_flag,
150: l_income_tax_region_asp,
151: l_basecur
152: FROM ap_system_parameters_all asp,
153: ap_invoices_all ai
154: WHERE ai.org_id = asp.org_id
155: and ai.invoice_id = p_invoice_id;
156:
157: debug_info := 'OPEN CURSOR C_Current_Line';

Line 664: debug_info := 'Update ap_invoices';

660: CLOSE c_payment_sched;
661: END Update_Payment_Schedules;
662:
663: <>
664: debug_info := 'Update ap_invoices';
665: UPDATE ap_invoices_all
666: SET awt_flag = DECODE(P_Create_dists, 'APPROVAL', 'Y','BOTH','Y', NULL), --Bug6660355
667: amount_applicable_to_discount = decode (sign(invoice_amount),
668: -1, amount_applicable_to_discount,

Line 665: UPDATE ap_invoices_all

661: END Update_Payment_Schedules;
662:
663: <>
664: debug_info := 'Update ap_invoices';
665: UPDATE ap_invoices_all
666: SET awt_flag = DECODE(P_Create_dists, 'APPROVAL', 'Y','BOTH','Y', NULL), --Bug6660355
667: amount_applicable_to_discount = decode (sign(invoice_amount),
668: -1, amount_applicable_to_discount,
669: amount_applicable_to_discount

Line 711: new_invoice_id ap_invoices.invoice_id%TYPE;

707: P_Dist_Line_No IN NUMBER DEFAULT NULL,
708: P_New_Invoice_Id IN NUMBER DEFAULT NULL,
709: P_create_dists IN VARCHAR2 DEFAULT NULL) --Bug7685907 bug8207324 bug8236169
710: IS
711: new_invoice_id ap_invoices.invoice_id%TYPE;
712: tax_authority_id ap_tax_codes.awt_vendor_id%TYPE;
713: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;
714: base_currency ap_system_parameters.base_currency_code%TYPE;
715: new_invoice_base_descr ap_invoices.description%TYPE;

Line 715: new_invoice_base_descr ap_invoices.description%TYPE;

711: new_invoice_id ap_invoices.invoice_id%TYPE;
712: tax_authority_id ap_tax_codes.awt_vendor_id%TYPE;
713: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;
714: base_currency ap_system_parameters.base_currency_code%TYPE;
715: new_invoice_base_descr ap_invoices.description%TYPE;
716: inv_terms_date DATE;
717: ta_terms_id po_vendor_sites.terms_id%TYPE;
718: ta_payment_priority po_vendor_sites.payment_priority%TYPE;
719: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;

Line 723: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;

719: ta_terms_date_basIS po_vendor_sites.terms_date_basIS%TYPE;
720: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
721: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
722: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
723: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
724: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
725: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
726: l_legal_entity_id ap_invoices_all.legal_entity_id%type;
727:

Line 724: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;

720: ta_pay_group_lookup_code po_vendor_sites.pay_group_lookup_code%TYPE;
721: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
722: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
723: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
724: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
725: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
726: l_legal_entity_id ap_invoices_all.legal_entity_id%type;
727:
728:

Line 726: l_legal_entity_id ap_invoices_all.legal_entity_id%type;

722: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
723: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
724: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
725: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
726: l_legal_entity_id ap_invoices_all.legal_entity_id%type;
727:
728:
729: l_IBY_PAYMENT_METHOD varchar2(80);
730: l_PAYMENT_REASON varchar2(80);

Line 780: ap_invoices_all AI

776: --, APID.ussgl_trx_code_context ussgl_trx_code_context - Bug 4277744
777: , APID.org_id
778: FROM ap_invoice_distributions_all APID,
779: ap_tax_codes_all ATC,
780: ap_invoices_all AI
781: WHERE (APID.invoice_id = InvId)
782: AND (APID.invoice_line_number = NVL(P_Inv_Line_No,invoice_line_number))
783: AND (APID.distribution_line_number = NVL(P_dist_Line_No,distribution_line_number))
784: AND (APID.line_type_lookup_code = 'AWT')

Line 816: , ap_invoices_all i

812: , 234
813: ) description,
814: i.legal_entity_id
815: FROM po_vendors v
816: , ap_invoices_all i
817: WHERE (v.vendor_id = i.vendor_id)
818: AND (i.invoice_id = InvId);
819:
820: DBG_Loc VARCHAR2(30) := 'Create_AWT_Invoices';

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

857: IS
858: SELECT t.awt_vendor_id,
859: t.awt_vendor_site_id,
860: NVL(s.payment_currency_code, s.invoice_currency_code),
861: NVL(P_New_Invoice_Id, ap_invoices_s.nextval),
862: p.base_currency_code,
863: s.terms_id,
864: s.payment_priority,
865: s.terms_date_basis,

Line 935: ap_invoices_pkg.get_payment_attributes(

931: --bug 7699166
932:
933:
934: --4610924, added this call to get payment attributes
935: ap_invoices_pkg.get_payment_attributes(
936: p_le_id =>l_legal_entity_id,
937: p_org_id =>rec_awt_lines.org_id,
938: p_payee_party_id => l_remit_party_id, --bug 7721149, replacing l_party_id for Third Party Payments
939: p_payee_party_site_id =>l_remit_to_party_site_id, --bug 7721149, replacing l_party_site_id for Third Party Payments

Line 992: FROM ap_invoices_all

988: SELECT invoice_received_date,
989: goods_received_date
990: INTO invoice_received_date,
991: goods_received_date
992: FROM ap_invoices_all
993: WHERE invoice_id = P_Invoice_Id;
994: END IF;
995:
996: debug_info := 'Insert Into ap_invoices';

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

992: FROM ap_invoices_all
993: WHERE invoice_id = P_Invoice_Id;
994: END IF;
995:
996: debug_info := 'Insert Into ap_invoices';
997:
998: INSERT INTO ap_invoices_all
999: (invoice_id
1000: ,last_UPDATE_date

Line 998: INSERT INTO ap_invoices_all

994: END IF;
995:
996: debug_info := 'Insert Into ap_invoices';
997:
998: INSERT INTO ap_invoices_all
999: (invoice_id
1000: ,last_UPDATE_date
1001: ,last_UPDATEd_by
1002: ,vendor_id

Line 1148: (p_table_name => 'AP_INVOICES',

1144:
1145:
1146: --Bug 4539462 DBI logging
1147: AP_DBI_PKG.Maintain_DBI_Summary
1148: (p_table_name => 'AP_INVOICES',
1149: p_operation => 'I',
1150: p_key_value1 => new_invoice_id,
1151: p_calling_sequence => current_calling_sequence);
1152:

Line 1475: l_awt_flag ap_invoices.awt_flag%TYPE;

1471: P_Invoice_Payment_Id IN NUMBER DEFAULT NULL,
1472: P_Check_Id IN NUMBER DEFAULT NULL,
1473: p_checkrun_id in number default null)
1474: IS
1475: l_awt_flag ap_invoices.awt_flag%TYPE;
1476: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
1477: l_tax_name ap_tax_codes.name%TYPE;
1478: l_payment_date DATE := p_awt_date;
1479: l_org_id number; --4742265

Line 1476: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;

1472: P_Check_Id IN NUMBER DEFAULT NULL,
1473: p_checkrun_id in number default null)
1474: IS
1475: l_awt_flag ap_invoices.awt_flag%TYPE;
1476: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
1477: l_tax_name ap_tax_codes.name%TYPE;
1478: l_payment_date DATE := p_awt_date;
1479: l_org_id number; --4742265
1480:

Line 1767: ap_invoices_all ai

1763: l_awt_flag,
1764: l_inv_curr_code,
1765: l_org_id --4742265
1766: FROM ap_system_parameters_all asp,
1767: ap_invoices_all ai
1768: WHERE ai.org_id = asp.org_id
1769: and ai.invoice_id = p_invoice_id;
1770:
1771: --Bug6660355

Line 2007: ap_invoices_all AI,

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
2011: AND AI.invoice_id = ASI.invoice_id

Line 2021: FROM ap_invoices AI

2017: AND AID.line_type_lookup_code = 'AWT'
2018: AND AID.awt_flag = 'M')
2019: AND ((ASP.create_awt_dists_type ='PAYMENT' --Bug6660355
2020: AND NOT EXISTS (SELECT 'Invoice already withheld by AutoApproval'
2021: FROM ap_invoices AI
2022: WHERE AI.invoice_id = ASI.invoice_id
2023: AND NVL(AI.awt_flag, 'N') = 'Y'))
2024: OR
2025: ASP.create_awt_dists_type ='BOTH')

Line 2116: FROM ap_invoice_distributions aid,ap_invoices ai

2112: AND payment_num = rec_ok_sel_invs.payment_num;
2113: --Bug6660355
2114: SELECT sum(nvl(aid.base_amount,aid.amount))
2115: INTO l_total_awt_amount
2116: FROM ap_invoice_distributions aid,ap_invoices ai
2117: WHERE aid.invoice_id = ai.invoice_id
2118: AND aid.invoice_id =rec_ok_sel_invs.invoice_id
2119: AND aid.line_type_lookup_code in ('AWT')
2120: AND aid.awt_origin_group_id = ai.awt_group_id;

Line 2419: , ap_invoices_all AI

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;
2423:

Line 2431: , ap_invoices_all AI

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
2435: and asi.checkrun_id = p_checkrun_id

Line 2561: ap_invoices_all AI,

2557: , AATD.tax_rate_id
2558: , TC.tax_id tax_code_id
2559: , aatd.checkrun_id
2560: FROM ap_awt_temp_distributions_all AATD,
2561: ap_invoices_all AI,
2562: ap_tax_codes_all TC
2563: WHERE AATD.invoice_id = InvId
2564: AND AATD.invoice_id = AI.invoice_id
2565: AND TC.name(+) = AATD.tax_name

Line 3021: ap_invoices AI

3017: , AID.invoice_distribution_id
3018: , AID.awt_related_id
3019: FROM ap_invoice_distributions AID,
3020: ap_tax_codes TC,
3021: ap_invoices AI
3022: WHERE AID.invoice_id = ParentId
3023: AND TC.tax_id (+) = AID.withholding_tax_code_id /* Bug 5382525 */
3024: AND AID.invoice_id = AI.invoice_id --6660355
3025: AND AID.awt_origin_group_id = AI.awt_group_id

Line 3150: l_invoice_exchange_rate ap_invoices.exchange_rate%type;

3146: -- only auto-generated AWT lines are to be considered
3147:
3148: rec_awt_dists c_awt_dists_pay%ROWTYPE;
3149:
3150: l_invoice_exchange_rate ap_invoices.exchange_rate%type;
3151: l_func_currency_code ap_system_parameters.base_currency_code%TYPE;
3152: l_old_inv_line_num ap_invoice_lines_all.line_number%TYPE;
3153:
3154: -- Ap_Undo_Withholding:

Line 3194: FROM AP_INVOICES_ALL AI

3190: debug_info := 'Select Org Id';
3191: IF (P_Calling_Module in ('CANCEL INVOICE','REVERSE DIST')) THEN
3192: SELECT AI.org_id
3193: INTO l_org_id
3194: FROM AP_INVOICES_ALL AI
3195: WHERE invoice_id = P_Parent_Id;
3196:
3197: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN
3198: SELECT AIP.org_id

Line 3301: FROM ap_invoices

3297: , exchange_rate_type
3298: -- , ussgl_transaction_code - Bug 4277744
3299: -- , ussgl_trx_code_context - Bug 4277744
3300: , vat_code
3301: FROM ap_invoices
3302: WHERE invoice_id = InvId
3303: FOR UPDATE;
3304: rec_invoice c_invoice%ROWTYPE;
3305:

Line 3504: ap_invoices AI

3500: , NVL(APS.inv_curr_gross_amount, APS.gross_Amount) inv_curr_gross_amount
3501: , APS.amount_remaining
3502: , AI.payment_currency_code
3503: FROM ap_payment_schedules APS,
3504: ap_invoices AI
3505: WHERE AI.invoice_id = InvId
3506: AND AI.invoice_id = APS.invoice_id
3507: AND APS.payment_num = NVL(PaymNum, APS.payment_num) /* Bug 5300858 */
3508: FOR UPDATE of APS.gross_amount, APS.inv_curr_gross_amount, APS.amount_remaining;

Line 3601: FROM ap_invoices ai, ap_invoice_payments aip

3597: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN
3598:
3599: SELECT ai.exchange_rate
3600: INTO l_invoice_exchange_rate
3601: FROM ap_invoices ai, ap_invoice_payments aip
3602: WHERE ai.invoice_id = aip.invoice_id
3603: AND aip.invoice_payment_id = rec_awt_dists.awt_invoice_payment_id;
3604: END IF;
3605: