View: ITG_SP_PO_PART_SOLDTO_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This view is used to generate partner sold to segment in Sync PO XML
Implementation/DBA Data:	APPS.ITG_SP_PO_PART_SOLDTO_V

View Text

SELECT PHA.PO_HEADER_ID
, PHA.BILL_TO_LOCATION_ID
, PHA.AGENT_ID
, HRLOC.INVENTORY_ORGANIZATION_ID INVORGID
, ORGDEF.SET_OF_BOOKS_ID
, ORGDEF.ORGANIZATION_NAME
, ORGDEF.ORGANIZATION_CODE PARTNRID
, 'SOLDTO' PARTNRTYPE
, GLSOB.CURRENCY_CODE CURRENCY
, HRLOC.INVENTORY_ORGANIZATION_ID PARTNRIDX
, 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 GL_SETS_OF_BOOKS GLSOB
, HR_LOCATIONS_ALL HRLOC
, HR_LOCATIONS_ALL_TL HRLOCTL
, PER_PEOPLE_F PER
, PO_HEADERS_ALL PHA
, ORG_ORGANIZATION_DEFINITIONS ORGDEF
WHERE GLSOB.SET_OF_BOOKS_ID = ORGDEF.SET_OF_BOOKS_ID
AND ORGDEF.ORGANIZATION_ID = HRLOC.INVENTORY_ORGANIZATION_ID
AND PER.PERSON_ID (+) = PHA.AGENT_ID
AND HRLOC.LOCATION_ID (+) = PHA.BILL_TO_LOCATION_ID
AND HRLOCTL.LOCATION_ID (+) = PHA.BILL_TO_LOCATION_ID
AND HRLOCTL.LANGUAGE = USERENV('LANG')
AND NVL(PER.EFFECTIVE_END_DATE
, SYSDATE+1) > SYSDATE

Columns