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.POS_ASN_NOTIF dependencies on PO_VENDOR_SITES_ALL

Line 656: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;

652: h_invoice_date DATE;
653: h_tax_amount NUMBER;
654:
655: l_remit_to_site_id NUMBER;
656: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
657: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;
658: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
659: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
660: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;

Line 657: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;

653: h_tax_amount NUMBER;
654:
655: l_remit_to_site_id NUMBER;
656: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
657: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;
658: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
659: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
660: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;
661: l_remit_to_czinfo VARCHAR2(200);

Line 658: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;

654:
655: l_remit_to_site_id NUMBER;
656: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
657: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;
658: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
659: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
660: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;
661: l_remit_to_czinfo VARCHAR2(200);
662: l_remit_to_country PO_VENDOR_SITES_ALL.country%TYPE;

Line 659: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;

655: l_remit_to_site_id NUMBER;
656: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
657: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;
658: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
659: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
660: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;
661: l_remit_to_czinfo VARCHAR2(200);
662: l_remit_to_country PO_VENDOR_SITES_ALL.country%TYPE;
663:

Line 660: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;

656: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
657: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;
658: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
659: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
660: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;
661: l_remit_to_czinfo VARCHAR2(200);
662: l_remit_to_country PO_VENDOR_SITES_ALL.country%TYPE;
663:
664: l_remit_exist_flag VARCHAR2(1) := 'T';

Line 662: l_remit_to_country PO_VENDOR_SITES_ALL.country%TYPE;

658: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
659: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
660: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;
661: l_remit_to_czinfo VARCHAR2(200);
662: l_remit_to_country PO_VENDOR_SITES_ALL.country%TYPE;
663:
664: l_remit_exist_flag VARCHAR2(1) := 'T';
665:
666:

Line 795: FROM PO_VENDOR_SITES_ALL pvs

791: l_remit_to_address3,
792: l_remit_to_address4,
793: l_remit_to_czinfo,
794: l_remit_to_country
795: FROM PO_VENDOR_SITES_ALL pvs
796: WHERE pvs.vendor_site_id = l_remit_to_site_id;
797:
798: EXCEPTION
799: WHEN NO_DATA_FOUND THEN