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 832: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;

828: x_buyer_user_name VARCHAR2(320);
829: x_buyer_user_displayname VARCHAR2(360);
830:
831: l_remit_to_site_id NUMBER;
832: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
833: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;
834: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
835: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
836: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;

Line 833: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;

829: x_buyer_user_displayname VARCHAR2(360);
830:
831: l_remit_to_site_id NUMBER;
832: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
833: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;
834: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
835: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
836: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;
837: l_remit_to_czinfo VARCHAR2(200);

Line 834: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;

830:
831: l_remit_to_site_id NUMBER;
832: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
833: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;
834: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
835: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
836: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;
837: l_remit_to_czinfo VARCHAR2(200);
838: l_remit_to_country PO_VENDOR_SITES_ALL.country%TYPE;

Line 835: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;

831: l_remit_to_site_id NUMBER;
832: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
833: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;
834: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
835: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
836: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;
837: l_remit_to_czinfo VARCHAR2(200);
838: l_remit_to_country PO_VENDOR_SITES_ALL.country%TYPE;
839:

Line 836: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;

832: l_remit_to_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
833: l_remit_to_address1 PO_VENDOR_SITES_ALL.address_line1%TYPE;
834: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
835: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
836: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;
837: l_remit_to_czinfo VARCHAR2(200);
838: l_remit_to_country PO_VENDOR_SITES_ALL.country%TYPE;
839:
840: l_remit_exist_flag VARCHAR2(1) := 'T';

Line 838: l_remit_to_country PO_VENDOR_SITES_ALL.country%TYPE;

834: l_remit_to_address2 PO_VENDOR_SITES_ALL.address_line2%TYPE;
835: l_remit_to_address3 PO_VENDOR_SITES_ALL.address_line3%TYPE;
836: l_remit_to_address4 PO_VENDOR_SITES_ALL.address_line4%TYPE;
837: l_remit_to_czinfo VARCHAR2(200);
838: l_remit_to_country PO_VENDOR_SITES_ALL.country%TYPE;
839:
840: l_remit_exist_flag VARCHAR2(1) := 'T';
841:
842:

Line 975: FROM PO_VENDOR_SITES_ALL pvs

971: l_remit_to_address3,
972: l_remit_to_address4,
973: l_remit_to_czinfo,
974: l_remit_to_country
975: FROM PO_VENDOR_SITES_ALL pvs
976: WHERE pvs.vendor_site_id = l_remit_to_site_id;
977:
978: EXCEPTION
979: WHEN NO_DATA_FOUND THEN