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_WORKFLOW_PKG dependencies on PO_VENDORS

Line 2700: po_vendors PV,

2696: NVL(AI.invoice_amount, 0) invoice_amount,
2697: AI.invoice_currency_code
2698: FROM
2699: ap_invoices_all AI,
2700: po_vendors PV,
2701: po_vendor_sites_all PVS
2702: WHERE
2703: AI.invoice_id = l_invoice_id AND
2704: AI.vendor_id = PV.vendor_id AND

Line 4425: po_vendors PV,

4421: NVL(AI.invoice_amount, 0),
4422: ahc.hold_instruction
4423: FROM ap_holds_all ah,
4424: ap_invoices_all AI,
4425: po_vendors PV,
4426: ap_hold_codes ahc
4427: WHERE ah.hold_id = p_hold_id
4428: AND AI.invoice_id = ah.invoice_id
4429: AND AI.vendor_id = PV.vendor_id

Line 4431: l_vendor_name po_vendors.vendor_name%TYPE;

4427: WHERE ah.hold_id = p_hold_id
4428: AND AI.invoice_id = ah.invoice_id
4429: AND AI.vendor_id = PV.vendor_id
4430: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4431: l_vendor_name po_vendors.vendor_name%TYPE;
4432: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4433: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4434: l_invoice_description ap_invoices_all.description%TYPE;
4435: l_invoice_id ap_invoices_all.invoice_id%TYPE;

Line 4700: po_vendors PV,

4696: NVL(AI.invoice_amount, 0),
4697: ahc.hold_instruction
4698: FROM ap_holds_all ah,
4699: ap_invoices_all AI,
4700: po_vendors PV,
4701: ap_lookup_codes alk,
4702: ap_hold_codes ahc
4703: WHERE ah.hold_id = p_hold_id
4704: AND alk.lookup_code = ah.hold_lookup_code

Line 4708: l_vendor_name po_vendors.vendor_name%TYPE;

4704: AND alk.lookup_code = ah.hold_lookup_code
4705: AND AI.invoice_id = ah.invoice_id
4706: AND AI.vendor_id = PV.vendor_id
4707: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4708: l_vendor_name po_vendors.vendor_name%TYPE;
4709: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4710: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4711: l_invoice_description ap_invoices_all.description%TYPE;
4712: l_invoice_id ap_invoices_all.invoice_id%TYPE;

Line 5623: po_vendors PV

5619: AI.approval_iteration,
5620: AI.vendor_contact_id,
5621: NVL(AI.invoice_amount, 0)
5622: FROM ap_invoices_all AI,
5623: po_vendors PV
5624: WHERE AI.invoice_id = p_invoice_id
5625: AND AI.vendor_id = PV.vendor_id;
5626: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';
5627: l_vendor_name po_vendors.vendor_name%TYPE;

Line 5627: l_vendor_name po_vendors.vendor_name%TYPE;

5623: po_vendors PV
5624: WHERE AI.invoice_id = p_invoice_id
5625: AND AI.vendor_id = PV.vendor_id;
5626: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';
5627: l_vendor_name po_vendors.vendor_name%TYPE;
5628: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5629: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5630: l_invoice_description ap_invoices_all.description%TYPE;
5631: l_invoice_id ap_invoices_all.invoice_id%TYPE;

Line 5898: l_vendor_name po_vendors.vendor_name%TYPE;

5894: WHERE AI.invoice_id = p_invoice_id
5895: AND AI.invoice_type_lookup_code = 'PAYMENT REQUEST'
5896: AND AI.party_id = HZP.party_id;
5897:
5898: l_vendor_name po_vendors.vendor_name%TYPE;
5899: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5900: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5901: l_invoice_description ap_invoices_all.description%TYPE;
5902: l_invoice_id ap_invoices_all.invoice_id%TYPE;