VIEW: APPS.ITG_SP_REL_LINE_PART_SHIPTO_V

Source

View Text - Preformatted

SELECT plla.po_header_id, plla.po_line_id, plla.line_location_id, plla.ship_to_location_id, plla.ship_to_organization_id, orgDef.organization_name name, orgDef.organization_code partnrID, 'ShipTo' partnrType, hrLocTL.location_code descriptn_partner, TO_CHAR(plla.ship_to_organization_id) partnridx, DECODE(hrLoc.tax_name, NULL, 0, 1) taxexempt, itg_x_utils.getTaxId(hrLoc.country, OrgDef.operating_unit, orgDef.organization_name, orgDef.operating_unit, hrLoc.inventory_organization_id) taxid, TO_CHAR(plla.line_location_id) UA_ref_schedlID, hrloc.address_line_1, hrloc.address_line_2, hrloc.address_line_3, hrLoc.town_or_city city, hrLoc.country, itg_x_utils.getCounty(hrLoc.style, hrLoc.region_1, hrLoc.region_2) county, hrLocTL.description descriptn_addrs, hrLoc.postal_code, itg_x_utils.getState(hrLoc.style, hrLoc.region_1, hrLoc.region_2) stateprovn, hrLoc.telephone_number_1 telephone FROM hr_locations_all hrLoc, hr_locations_all_tl hrLocTL, org_organization_definitions orgDef, po_line_locations_all plla WHERE orgDef.organization_id (+) = plla.ship_to_organization_id AND hrLoc.location_id (+) = plla.ship_to_location_id AND hrLocTL.location_id (+) = plla.ship_to_location_id AND hrLocTL.LANGUAGE (+)= userenv('LANG') and NVL(plla.shipment_type,'xx') <> 'PREPAYMENT'

View Text - HTML Formatted

SELECT PLLA.PO_HEADER_ID
, PLLA.PO_LINE_ID
, PLLA.LINE_LOCATION_ID
, PLLA.SHIP_TO_LOCATION_ID
, PLLA.SHIP_TO_ORGANIZATION_ID
, ORGDEF.ORGANIZATION_NAME NAME
, ORGDEF.ORGANIZATION_CODE PARTNRID
, 'SHIPTO' PARTNRTYPE
, HRLOCTL.LOCATION_CODE DESCRIPTN_PARTNER
, TO_CHAR(PLLA.SHIP_TO_ORGANIZATION_ID) PARTNRIDX
, DECODE(HRLOC.TAX_NAME
, NULL
, 0
, 1) TAXEXEMPT
, ITG_X_UTILS.GETTAXID(HRLOC.COUNTRY
, ORGDEF.OPERATING_UNIT
, ORGDEF.ORGANIZATION_NAME
, ORGDEF.OPERATING_UNIT
, HRLOC.INVENTORY_ORGANIZATION_ID) TAXID
, TO_CHAR(PLLA.LINE_LOCATION_ID) UA_REF_SCHEDLID
, HRLOC.ADDRESS_LINE_1
, HRLOC.ADDRESS_LINE_2
, HRLOC.ADDRESS_LINE_3
, HRLOC.TOWN_OR_CITY CITY
, HRLOC.COUNTRY
, ITG_X_UTILS.GETCOUNTY(HRLOC.STYLE
, HRLOC.REGION_1
, HRLOC.REGION_2) COUNTY
, HRLOCTL.DESCRIPTION DESCRIPTN_ADDRS
, HRLOC.POSTAL_CODE
, ITG_X_UTILS.GETSTATE(HRLOC.STYLE
, HRLOC.REGION_1
, HRLOC.REGION_2) STATEPROVN
, HRLOC.TELEPHONE_NUMBER_1 TELEPHONE
FROM HR_LOCATIONS_ALL HRLOC
, HR_LOCATIONS_ALL_TL HRLOCTL
, ORG_ORGANIZATION_DEFINITIONS ORGDEF
, PO_LINE_LOCATIONS_ALL PLLA
WHERE ORGDEF.ORGANIZATION_ID (+) = PLLA.SHIP_TO_ORGANIZATION_ID
AND HRLOC.LOCATION_ID (+) = PLLA.SHIP_TO_LOCATION_ID
AND HRLOCTL.LOCATION_ID (+) = PLLA.SHIP_TO_LOCATION_ID
AND HRLOCTL.LANGUAGE (+)= USERENV('LANG')
AND NVL(PLLA.SHIPMENT_TYPE
, 'XX') <> 'PREPAYMENT'