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 2602: po_vendors PV,

2598: NVL(AI.invoice_amount, 0) invoice_amount,
2599: AI.invoice_currency_code
2600: FROM
2601: ap_invoices_all AI,
2602: po_vendors PV,
2603: po_vendor_sites_all PVS
2604: WHERE
2605: AI.invoice_id = l_invoice_id AND
2606: AI.vendor_id = PV.vendor_id AND

Line 4298: po_vendors PV,

4294: NVL(AI.invoice_amount, 0),
4295: ahc.hold_instruction
4296: FROM ap_holds_all ah,
4297: ap_invoices_all AI,
4298: po_vendors PV,
4299: ap_hold_codes ahc
4300: WHERE ah.hold_id = p_hold_id
4301: AND AI.invoice_id = ah.invoice_id
4302: AND AI.vendor_id = PV.vendor_id

Line 4304: l_vendor_name po_vendors.vendor_name%TYPE;

4300: WHERE ah.hold_id = p_hold_id
4301: AND AI.invoice_id = ah.invoice_id
4302: AND AI.vendor_id = PV.vendor_id
4303: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4304: l_vendor_name po_vendors.vendor_name%TYPE;
4305: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4306: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4307: l_invoice_description ap_invoices_all.description%TYPE;
4308: l_invoice_id ap_invoices_all.invoice_id%TYPE;

Line 4568: po_vendors PV,

4564: NVL(AI.invoice_amount, 0),
4565: ahc.hold_instruction
4566: FROM ap_holds_all ah,
4567: ap_invoices_all AI,
4568: po_vendors PV,
4569: ap_lookup_codes alk,
4570: ap_hold_codes ahc
4571: WHERE ah.hold_id = p_hold_id
4572: AND alk.lookup_code = ah.hold_lookup_code

Line 4576: l_vendor_name po_vendors.vendor_name%TYPE;

4572: AND alk.lookup_code = ah.hold_lookup_code
4573: AND AI.invoice_id = ah.invoice_id
4574: AND AI.vendor_id = PV.vendor_id
4575: AND AH.hold_lookup_code = AHC.hold_lookup_code;
4576: l_vendor_name po_vendors.vendor_name%TYPE;
4577: l_invoice_num ap_invoices_all.invoice_num%TYPE;
4578: l_invoice_date ap_invoices_all.invoice_date%TYPE;
4579: l_invoice_description ap_invoices_all.description%TYPE;
4580: l_invoice_id ap_invoices_all.invoice_id%TYPE;

Line 5382: po_vendors PV

5378: AI.approval_iteration,
5379: AI.vendor_contact_id,
5380: NVL(AI.invoice_amount, 0)
5381: FROM ap_invoices_all AI,
5382: po_vendors PV
5383: WHERE AI.invoice_id = p_invoice_id
5384: AND AI.vendor_id = PV.vendor_id;
5385: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';
5386: l_vendor_name po_vendors.vendor_name%TYPE;

Line 5386: l_vendor_name po_vendors.vendor_name%TYPE;

5382: po_vendors PV
5383: WHERE AI.invoice_id = p_invoice_id
5384: AND AI.vendor_id = PV.vendor_id;
5385: l_api_name CONSTANT VARCHAR2(200) := 'create_lineapproval_neg_process';
5386: l_vendor_name po_vendors.vendor_name%TYPE;
5387: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5388: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5389: l_invoice_description ap_invoices_all.description%TYPE;
5390: l_invoice_id ap_invoices_all.invoice_id%TYPE;

Line 5657: l_vendor_name po_vendors.vendor_name%TYPE;

5653: WHERE AI.invoice_id = p_invoice_id
5654: AND AI.invoice_type_lookup_code = 'PAYMENT REQUEST'
5655: AND AI.party_id = HZP.party_id;
5656:
5657: l_vendor_name po_vendors.vendor_name%TYPE;
5658: l_invoice_num ap_invoices_all.invoice_num%TYPE;
5659: l_invoice_date ap_invoices_all.invoice_date%TYPE;
5660: l_invoice_description ap_invoices_all.description%TYPE;
5661: l_invoice_id ap_invoices_all.invoice_id%TYPE;