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.PO_INVOICES_SV2 dependencies on PO_VENDOR_SITES

Line 215: FROM po_vendor_sites pvss,

211: NVL(rsl.osa_flag,'N') osa_flag, --Shikyu project
212: plls.match_option, -- 5100177
213: rts.unit_of_measure, -- 5100177
214: plls.unit_meas_lookup_code -- 5100177
215: FROM po_vendor_sites pvss,
216: po_vendor_sites pvss2,
217: po_vendors pvds,
218: --Bugfix 5407632 - Using _all tables instead of views.
219: po_headers_all phs,

Line 216: po_vendor_sites pvss2,

212: plls.match_option, -- 5100177
213: rts.unit_of_measure, -- 5100177
214: plls.unit_meas_lookup_code -- 5100177
215: FROM po_vendor_sites pvss,
216: po_vendor_sites pvss2,
217: po_vendors pvds,
218: --Bugfix 5407632 - Using _all tables instead of views.
219: po_headers_all phs,
220: -- po_releases_all prs, /*Bug 5443196*/

Line 293: FROM po_vendor_sites pvss,

289: NVL(rsl.osa_flag,'N') osa_flag, --Shikyu project
290: plls.match_option, -- 5100177
291: rts.unit_of_measure, -- 5100177
292: plls.unit_meas_lookup_code -- 5100177
293: FROM po_vendor_sites pvss,
294: po_vendor_sites pvss2,
295: po_vendors pvds,
296: --Bugfix 5407632 - Using _all tables instead of views.
297: po_headers_all phs,

Line 294: po_vendor_sites pvss2,

290: plls.match_option, -- 5100177
291: rts.unit_of_measure, -- 5100177
292: plls.unit_meas_lookup_code -- 5100177
293: FROM po_vendor_sites pvss,
294: po_vendor_sites pvss2,
295: po_vendors pvds,
296: --Bugfix 5407632 - Using _all tables instead of views.
297: po_headers_all phs,
298: po_releases_all prs,

Line 391: FROM po_vendor_sites pvss,

387: rsl.osa_flag, --Shikyu project
388: plls.match_option, -- 5100177
389: rts.unit_of_measure, -- 5100177
390: plls.unit_meas_lookup_code -- 5100177
391: FROM po_vendor_sites pvss,
392: po_vendor_sites pvss2,
393: po_vendors pvds,
394: po_headers phs,
395: po_releases prs,

Line 392: po_vendor_sites pvss2,

388: plls.match_option, -- 5100177
389: rts.unit_of_measure, -- 5100177
390: plls.unit_meas_lookup_code -- 5100177
391: FROM po_vendor_sites pvss,
392: po_vendor_sites pvss2,
393: po_vendors pvds,
394: po_headers phs,
395: po_releases prs,
396: po_lines pls,

Line 485: X_curr_pay_curr_code po_vendor_sites.payment_currency_code%TYPE;

481: /** Bug 586895 **/
482: X_curr_method_code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE;
483:
484: /* Bug 612979 **/
485: X_curr_pay_curr_code po_vendor_sites.payment_currency_code%TYPE;
486: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;
487:
488: /*** vendor, vendor-pay-site related varibles ***/
489:

Line 486: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;

482: X_curr_method_code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE;
483:
484: /* Bug 612979 **/
485: X_curr_pay_curr_code po_vendor_sites.payment_currency_code%TYPE;
486: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;
487:
488: /*** vendor, vendor-pay-site related varibles ***/
489:
490: X_pay_group_lookup_code po_vendors.pay_group_lookup_code%TYPE;

Line 494: X_vendor_income_tax_region po_vendor_sites.state%TYPE;

490: X_pay_group_lookup_code po_vendors.pay_group_lookup_code%TYPE;
491: X_payment_method_lookup_code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE;
492: X_payment_priority po_vendors.payment_priority%TYPE;
493: X_terms_date_basis po_vendors.terms_date_basis%TYPE;
494: X_vendor_income_tax_region po_vendor_sites.state%TYPE;
495: X_type_1099 po_vendors.type_1099%TYPE;
496: X_awt_flag po_Vendor_sites.allow_awt_flag%TYPE;
497: X_awt_group_id po_vendor_sites.awt_group_id%TYPE;
498: X_exclude_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;

Line 496: X_awt_flag po_Vendor_sites.allow_awt_flag%TYPE;

492: X_payment_priority po_vendors.payment_priority%TYPE;
493: X_terms_date_basis po_vendors.terms_date_basis%TYPE;
494: X_vendor_income_tax_region po_vendor_sites.state%TYPE;
495: X_type_1099 po_vendors.type_1099%TYPE;
496: X_awt_flag po_Vendor_sites.allow_awt_flag%TYPE;
497: X_awt_group_id po_vendor_sites.awt_group_id%TYPE;
498: X_exclude_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
499: X_unit_meas_lookup_code varchar2(25);
500:

Line 497: X_awt_group_id po_vendor_sites.awt_group_id%TYPE;

493: X_terms_date_basis po_vendors.terms_date_basis%TYPE;
494: X_vendor_income_tax_region po_vendor_sites.state%TYPE;
495: X_type_1099 po_vendors.type_1099%TYPE;
496: X_awt_flag po_Vendor_sites.allow_awt_flag%TYPE;
497: X_awt_group_id po_vendor_sites.awt_group_id%TYPE;
498: X_exclude_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
499: X_unit_meas_lookup_code varchar2(25);
500:
501: /* BUG 612979 */

Line 498: X_exclude_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;

494: X_vendor_income_tax_region po_vendor_sites.state%TYPE;
495: X_type_1099 po_vendors.type_1099%TYPE;
496: X_awt_flag po_Vendor_sites.allow_awt_flag%TYPE;
497: X_awt_group_id po_vendor_sites.awt_group_id%TYPE;
498: X_exclude_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
499: X_unit_meas_lookup_code varchar2(25);
500:
501: /* BUG 612979 */
502:

Line 503: X_payment_currency_code po_vendor_sites.payment_currency_code%TYPE := NULL;

499: X_unit_meas_lookup_code varchar2(25);
500:
501: /* BUG 612979 */
502:
503: X_payment_currency_code po_vendor_sites.payment_currency_code%TYPE := NULL;
504: X_pay_cross_rate NUMBER;
505:
506: X_batch_id NUMBER;
507: X_discountable_amount NUMBER;

Line 538: X_curr_por_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE := NULL; /* bug 7512542 */

534: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
535: l_tax_classification_code VARCHAR2(30);
536:
537: X_curr_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL; /* bug 7512542 */
538: X_curr_por_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE := NULL; /* bug 7512542 */
539: X_curr_org_id NUMBER :=NULL; /* bug 7512542 */
540:
541:
542: BEGIN

Line 1547: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;

1543:
1544: X_progress VARCHAR2(3) := NULL;
1545: X_discountable_amount NUMBER;
1546: X_pay_cross_rate NUMBER;
1547: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;
1548:
1549: BEGIN
1550: IF (g_asn_debug = 'Y') THEN
1551: asn_debug.put_line('Wrapping up the current invoice ... ');

Line 2249: Getting tax rounding rule from po_vendor_sites for the

2245:
2246: X_progress := '010';
2247:
2248: /* Fix for bug 3050752.
2249: Getting tax rounding rule from po_vendor_sites for the
2250: associated PO vendor site.
2251: */
2252:
2253: