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.

VIEW: APPS.ITG_SP_PO_PART_SHIPTO_V

Source

View Text - Preformatted


SELECT pha.po_header_id, pha.vendor_id, pha.agent_id, pha.ship_to_location_id, hrLoc.location_code name, per.employee_number partnrid, 'ShipTo' partnrtype, hrLocTL.description, pha.ship_to_location_id partnridx, DECODE(hrLoc.tax_name, NULL, '1', '0') taxexempt, ven.vat_registration_num taxid, hrloc.bill_to_site_flag ua_sold_billflag, hrloc.ship_to_site_flag ua_sold_shipflag, hrloc.receiving_site_flag ua_sold_recflag, hrloc.address_line_1, hrloc.address_line_2, hrloc.address_line_3, NULL addrtype, hrloc.town_or_city city, hrloc.country, itg_x_utils.getCounty(hrLoc.style, hrLoc.region_1, hrLoc.region_2) county, hrLocTL.description site_descriptn, hrLoc.postal_code, itg_x_utils.getState(hrLoc.style, hrLoc.region_1, hrLoc.region_2) stateprovn, hrLoc.telephone_number_1 telephone, per.full_name contact_name, per.email_address contact_email, per.work_telephone contact_phone FROM hr_locations_all hrLoc, hr_locations_all_tl hrLocTL, per_people_f per, po_headers_all pha, po_vendors ven WHERE ven.vendor_id (+) = pha.vendor_id AND per.person_id (+) = pha.agent_id AND hrLoc.location_id (+) = pha.ship_to_location_id AND hrLocTL.location_id (+) = pha.ship_to_location_id AND hrLocTL.LANGUAGE(+)= userenv('LANG') AND nvl(per.effective_end_date,sysdate+1) > sysdate

View Text - HTML Formatted

SELECT PHA.PO_HEADER_ID
, PHA.VENDOR_ID
, PHA.AGENT_ID
, PHA.SHIP_TO_LOCATION_ID
, HRLOC.LOCATION_CODE NAME
, PER.EMPLOYEE_NUMBER PARTNRID
, 'SHIPTO' PARTNRTYPE
, HRLOCTL.DESCRIPTION
, PHA.SHIP_TO_LOCATION_ID PARTNRIDX
, DECODE(HRLOC.TAX_NAME
, NULL
, '1'
, '0') TAXEXEMPT
, VEN.VAT_REGISTRATION_NUM TAXID
, HRLOC.BILL_TO_SITE_FLAG UA_SOLD_BILLFLAG
, HRLOC.SHIP_TO_SITE_FLAG UA_SOLD_SHIPFLAG
, HRLOC.RECEIVING_SITE_FLAG UA_SOLD_RECFLAG
, HRLOC.ADDRESS_LINE_1
, HRLOC.ADDRESS_LINE_2
, HRLOC.ADDRESS_LINE_3
, NULL ADDRTYPE
, HRLOC.TOWN_OR_CITY CITY
, HRLOC.COUNTRY
, ITG_X_UTILS.GETCOUNTY(HRLOC.STYLE
, HRLOC.REGION_1
, HRLOC.REGION_2) COUNTY
, HRLOCTL.DESCRIPTION SITE_DESCRIPTN
, HRLOC.POSTAL_CODE
, ITG_X_UTILS.GETSTATE(HRLOC.STYLE
, HRLOC.REGION_1
, HRLOC.REGION_2) STATEPROVN
, HRLOC.TELEPHONE_NUMBER_1 TELEPHONE
, PER.FULL_NAME CONTACT_NAME
, PER.EMAIL_ADDRESS CONTACT_EMAIL
, PER.WORK_TELEPHONE CONTACT_PHONE
FROM HR_LOCATIONS_ALL HRLOC
, HR_LOCATIONS_ALL_TL HRLOCTL
, PER_PEOPLE_F PER
, PO_HEADERS_ALL PHA
, PO_VENDORS VEN
WHERE VEN.VENDOR_ID (+) = PHA.VENDOR_ID
AND PER.PERSON_ID (+) = PHA.AGENT_ID
AND HRLOC.LOCATION_ID (+) = PHA.SHIP_TO_LOCATION_ID
AND HRLOCTL.LOCATION_ID (+) = PHA.SHIP_TO_LOCATION_ID
AND HRLOCTL.LANGUAGE(+)= USERENV('LANG')
AND NVL(PER.EFFECTIVE_END_DATE
, SYSDATE+1) > SYSDATE