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.

[Home] [Help]

APPS.PO_INVOICES_SV2 dependencies on PO_VENDOR_SITES

Line 225: FROM po_vendor_sites pvss,

221: NVL(rsl.osa_flag,'N') osa_flag, --Shikyu project
222: plls.match_option, -- 5100177
223: rts.unit_of_measure, -- 5100177
224: plls.unit_meas_lookup_code -- 5100177
225: FROM po_vendor_sites pvss,
226: po_vendor_sites pvss2,
227: po_vendors pvds,
228: --Bugfix 5407632 - Using _all tables instead of views.
229: po_headers_all phs,

Line 226: po_vendor_sites pvss2,

222: plls.match_option, -- 5100177
223: rts.unit_of_measure, -- 5100177
224: plls.unit_meas_lookup_code -- 5100177
225: FROM po_vendor_sites pvss,
226: po_vendor_sites pvss2,
227: po_vendors pvds,
228: --Bugfix 5407632 - Using _all tables instead of views.
229: po_headers_all phs,
230: -- po_releases_all prs, /*Bug 5443196*/

Line 320: FROM po_vendor_sites pvss,

316: NVL(rsl.osa_flag,'N') osa_flag, --Shikyu project
317: plls.match_option, -- 5100177
318: rts.unit_of_measure, -- 5100177
319: plls.unit_meas_lookup_code -- 5100177
320: FROM po_vendor_sites pvss,
321: po_vendor_sites pvss2,
322: po_vendors pvds,
323: --Bugfix 5407632 - Using _all tables instead of views.
324: po_headers_all phs,

Line 321: po_vendor_sites pvss2,

317: plls.match_option, -- 5100177
318: rts.unit_of_measure, -- 5100177
319: plls.unit_meas_lookup_code -- 5100177
320: FROM po_vendor_sites pvss,
321: po_vendor_sites pvss2,
322: po_vendors pvds,
323: --Bugfix 5407632 - Using _all tables instead of views.
324: po_headers_all phs,
325: po_releases_all prs,

Line 435: FROM po_vendor_sites pvss,

431: rsl.osa_flag, --Shikyu project
432: plls.match_option, -- 5100177
433: rts.unit_of_measure, -- 5100177
434: plls.unit_meas_lookup_code -- 5100177
435: FROM po_vendor_sites pvss,
436: po_vendor_sites pvss2,
437: po_vendors pvds,
438: po_headers phs,
439: po_releases prs,

Line 436: po_vendor_sites pvss2,

432: plls.match_option, -- 5100177
433: rts.unit_of_measure, -- 5100177
434: plls.unit_meas_lookup_code -- 5100177
435: FROM po_vendor_sites pvss,
436: po_vendor_sites pvss2,
437: po_vendors pvds,
438: po_headers phs,
439: po_releases prs,
440: po_lines pls,

Line 536: X_curr_pay_curr_code po_vendor_sites.payment_currency_code%TYPE;

532: /** Bug 586895 **/
533: X_curr_method_code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE;
534:
535: /* Bug 612979 **/
536: X_curr_pay_curr_code po_vendor_sites.payment_currency_code%TYPE;
537: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;
538:
539: /*** vendor, vendor-pay-site related varibles ***/
540:

Line 537: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;

533: X_curr_method_code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE;
534:
535: /* Bug 612979 **/
536: X_curr_pay_curr_code po_vendor_sites.payment_currency_code%TYPE;
537: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;
538:
539: /*** vendor, vendor-pay-site related varibles ***/
540:
541: X_pay_group_lookup_code po_vendors.pay_group_lookup_code%TYPE;

Line 545: X_vendor_income_tax_region po_vendor_sites.state%TYPE;

541: X_pay_group_lookup_code po_vendors.pay_group_lookup_code%TYPE;
542: X_payment_method_lookup_code IBY_PAYMENT_METHODS_VL.PAYMENT_METHOD_CODE%TYPE;
543: X_payment_priority po_vendors.payment_priority%TYPE;
544: X_terms_date_basis po_vendors.terms_date_basis%TYPE;
545: X_vendor_income_tax_region po_vendor_sites.state%TYPE;
546: X_type_1099 po_vendors.type_1099%TYPE;
547: X_awt_flag po_Vendor_sites.allow_awt_flag%TYPE;
548: X_awt_group_id po_vendor_sites.awt_group_id%TYPE;
549: X_exclude_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;

Line 547: X_awt_flag po_Vendor_sites.allow_awt_flag%TYPE;

543: X_payment_priority po_vendors.payment_priority%TYPE;
544: X_terms_date_basis po_vendors.terms_date_basis%TYPE;
545: X_vendor_income_tax_region po_vendor_sites.state%TYPE;
546: X_type_1099 po_vendors.type_1099%TYPE;
547: X_awt_flag po_Vendor_sites.allow_awt_flag%TYPE;
548: X_awt_group_id po_vendor_sites.awt_group_id%TYPE;
549: X_exclude_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
550: X_unit_meas_lookup_code varchar2(25);
551:

Line 548: X_awt_group_id po_vendor_sites.awt_group_id%TYPE;

544: X_terms_date_basis po_vendors.terms_date_basis%TYPE;
545: X_vendor_income_tax_region po_vendor_sites.state%TYPE;
546: X_type_1099 po_vendors.type_1099%TYPE;
547: X_awt_flag po_Vendor_sites.allow_awt_flag%TYPE;
548: X_awt_group_id po_vendor_sites.awt_group_id%TYPE;
549: X_exclude_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
550: X_unit_meas_lookup_code varchar2(25);
551:
552: /* BUG 612979 */

Line 549: X_exclude_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;

545: X_vendor_income_tax_region po_vendor_sites.state%TYPE;
546: X_type_1099 po_vendors.type_1099%TYPE;
547: X_awt_flag po_Vendor_sites.allow_awt_flag%TYPE;
548: X_awt_group_id po_vendor_sites.awt_group_id%TYPE;
549: X_exclude_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
550: X_unit_meas_lookup_code varchar2(25);
551:
552: /* BUG 612979 */
553:

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

550: X_unit_meas_lookup_code varchar2(25);
551:
552: /* BUG 612979 */
553:
554: X_payment_currency_code po_vendor_sites.payment_currency_code%TYPE := NULL;
555: X_pay_cross_rate NUMBER;
556:
557: X_batch_id NUMBER;
558: X_discountable_amount NUMBER;

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

585: l_ship_to_location_id PO_LINE_LOCATIONS.SHIP_TO_LOCATION_ID%TYPE;
586: l_tax_classification_code VARCHAR2(30);
587:
588: X_curr_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL; /* bug 7512542 */
589: X_curr_por_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE := NULL; /* bug 7512542 */
590: X_curr_org_id NUMBER :=NULL; /* bug 7512542 */
591:
592:
593: BEGIN

Line 1611: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;

1607:
1608: X_progress VARCHAR2(3) := NULL;
1609: X_discountable_amount NUMBER;
1610: X_pay_cross_rate NUMBER;
1611: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;
1612:
1613: BEGIN
1614: IF (g_asn_debug = 'Y') THEN
1615: asn_debug.put_line('Wrapping up the current invoice ... ');

Line 2346: Getting tax rounding rule from po_vendor_sites for the

2342:
2343: X_progress := '010';
2344:
2345: /* Fix for bug 3050752.
2346: Getting tax rounding rule from po_vendor_sites for the
2347: associated PO vendor site.
2348: */
2349:
2350: