APPS.PO_INVOICES_SV2 dependencies on PO_VENDOR_SITES

Line 27: po_vendor_sites.pay_on_receipt_summary_code%TYPE INDEX BY BINARY_INTEGER;

23: TYPE vendor_id_tbl_type IS TABLE OF
24: po_vendors.vendor_id%TYPE INDEX BY BINARY_INTEGER;
25:
26: TYPE pay_on_rec_sum_code_tbl_type IS TABLE OF
27: po_vendor_sites.pay_on_receipt_summary_code%TYPE INDEX BY BINARY_INTEGER;
28:
29: TYPE vendor_site_id_tbl_type IS TABLE OF
30: po_vendor_sites.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
31:

Line 30: po_vendor_sites.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;

26: TYPE pay_on_rec_sum_code_tbl_type IS TABLE OF
27: po_vendor_sites.pay_on_receipt_summary_code%TYPE INDEX BY BINARY_INTEGER;
28:
29: TYPE vendor_site_id_tbl_type IS TABLE OF
30: po_vendor_sites.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
31:
32: TYPE item_description_tbl_type IS TABLE OF
33: PO_LINES.item_description%TYPE INDEX BY BINARY_INTEGER;
34:

Line 81: po_vendor_sites.payment_currency_code%TYPE INDEX BY BINARY_INTEGER;

77: TYPE description_tbl_type IS TABLE OF
78: ap_invoices_interface.description%TYPE INDEX BY BINARY_INTEGER;
79:
80: TYPE pay_curr_code_tbl_type IS TABLE OF
81: po_vendor_sites.payment_currency_code%TYPE INDEX BY BINARY_INTEGER;
82:
83: TYPE terms_id_tbl_type IS TABLE OF
84: ap_invoices_interface.terms_id%TYPE INDEX BY BINARY_INTEGER;
85:

Line 141: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,

137: group_id group_id_tbl_type,
138: org_id org_id_tbl_type);
139:
140: TYPE curr_condition_rec_type IS RECORD (
141: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,
142: invoice_amount ap_invoices_interface.invoice_amount%TYPE,
143: invoice_id ap_invoices_interface.invoice_id%TYPE,
144: invoice_num ap_invoices_interface.invoice_num%TYPE,
145: vendor_id po_vendors.vendor_id%TYPE,

Line 146: pay_site_id po_vendor_sites.vendor_site_id%TYPE,

142: invoice_amount ap_invoices_interface.invoice_amount%TYPE,
143: invoice_id ap_invoices_interface.invoice_id%TYPE,
144: invoice_num ap_invoices_interface.invoice_num%TYPE,
145: vendor_id po_vendors.vendor_id%TYPE,
146: pay_site_id po_vendor_sites.vendor_site_id%TYPE,
147: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE,
148: po_header_id po_headers.po_header_id%TYPE,
149: po_release_id po_releases.po_release_id%TYPE,
150: currency_code po_headers.currency_code%TYPE,

Line 147: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE,

143: invoice_id ap_invoices_interface.invoice_id%TYPE,
144: invoice_num ap_invoices_interface.invoice_num%TYPE,
145: vendor_id po_vendors.vendor_id%TYPE,
146: pay_site_id po_vendor_sites.vendor_site_id%TYPE,
147: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE,
148: po_header_id po_headers.po_header_id%TYPE,
149: po_release_id po_releases.po_release_id%TYPE,
150: currency_code po_headers.currency_code%TYPE,
151: conversion_rate po_headers.rate%TYPE,

Line 196: PO_VENDOR_SITES pvs,

192: poh.org_id ORG_ID,
193: poll.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE --5100177
194: FROM
195: PO_VENDORS pv,
196: PO_VENDOR_SITES pvs,
197: PO_VENDOR_SITES pvs2,
198: PO_HEADERS poh,
199: PO_LINES pol,
200: PO_LINE_LOCATIONS poll,

Line 197: PO_VENDOR_SITES pvs2,

193: poll.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE --5100177
194: FROM
195: PO_VENDORS pv,
196: PO_VENDOR_SITES pvs,
197: PO_VENDOR_SITES pvs2,
198: PO_HEADERS poh,
199: PO_LINES pol,
200: PO_LINE_LOCATIONS poll,
201: PO_DISTRIBUTIONS pod

Line 259: PO_VENDOR_SITES pvs,

255: por.org_id ORG_ID,
256: poll.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE --5100177
257: FROM
258: PO_VENDORS pv,
259: PO_VENDOR_SITES pvs,
260: PO_VENDOR_SITES pvs2,
261: PO_HEADERS poh,
262: PO_RELEASES por,
263: PO_LINES pol,

Line 260: PO_VENDOR_SITES pvs2,

256: poll.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE --5100177
257: FROM
258: PO_VENDORS pv,
259: PO_VENDOR_SITES pvs,
260: PO_VENDOR_SITES pvs2,
261: PO_HEADERS poh,
262: PO_RELEASES por,
263: PO_LINES pol,
264: PO_LINE_LOCATIONS poll,