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_ALL

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