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.

[Home] [Help]

View: OKX_PARTY_SITES_V

Product:	OKX - Contracts Integration
Description:	Party site uses
Implementation/DBA Data:	APPS.OKX_PARTY_SITES_V

View Text

SELECT PSE.PARTY_SITE_ID ID1
, '#' ID2
, PSE.LOCATION_ID LOCATION_ID
, PSE.PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, PSE.PARTY_ID PARTY_ID
, PSE.PARTY_SITE_NAME NAME
, PSE.STATUS STATUS
, LCN.COUNTRY COUNTRY
, LCN.ADDRESS1 ADDRESS1
, LCN.ADDRESS2 ADDRESS2
, LCN.ADDRESS3 ADDRESS3
, LCN.ADDRESS4 ADDRESS4
, LCN.CITY CITY
, LCN.POSTAL_CODE POSTAL_CODE
, LCN.STATE STATE
, LCN.PROVINCE PROVINCE
, LCN.COUNTY COUNTY
, LCN.DESCRIPTION LOCATION_DESCRIPTION
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, LCN.ADDRESS1
, LCN.ADDRESS2
, LCN.ADDRESS3
, LCN.ADDRESS4
, LCN.CITY
, LCN.COUNTY
, LCN.STATE
, LCN.PROVINCE
, LCN.POSTAL_CODE
, NULL
, LCN.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) DESCRIPTION
, PSE.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS_FLAG
, PSE.ADDRESSEE ADDRESSEE
FROM HZ_PARTY_SITES PSE
, HZ_LOCATIONS LCN
WHERE LCN.LOCATION_ID = PSE.LOCATION_ID
AND LCN.CONTENT_SOURCE_TYPE = 'USER_ENTERED'

Columns

Name
ID1
ID2
LOCATION_ID
PARTY_SITE_NUMBER
PARTY_ID
NAME
STATUS
COUNTRY
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
POSTAL_CODE
STATE
PROVINCE
COUNTY
LOCATION_DESCRIPTION
DESCRIPTION
IDENTIFYING_ADDRESS_FLAG
ADDRESSEE