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_CUST_SITES_V

Product:	OKX - Contracts Integration
Description:	Customer site uses
Implementation/DBA Data:	APPS.OKX_CUST_SITES_V

View Text

SELECT CA.CUST_ACCT_SITE_ID ID1
, '#' ID2
, CA.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, CA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CA.PARTY_SITE_ID PARTY_SITE_ID
, PS.PARTY_ID PARTY_ID
, PS.PARTY_SITE_NAME PARTY_SITE_NAME
, CA.STATUS STATUS
, L.LOCATION_ID LOCATION_ID
, PS.PARTY_SITE_NAME NAME
, L.COUNTRY COUNTRY
, L.ADDRESS1 ADDRESS1
, L.ADDRESS2 ADDRESS2
, L.ADDRESS3 ADDRESS3
, L.ADDRESS4 ADDRESS4
, L.CITY CITY
, L.POSTAL_CODE POSTAL_CODE
, L.STATE STATE
, L.PROVINCE PROVINCE
, L.COUNTY COUNTY
, L.DESCRIPTION LOCATION_DESCRIPTION
, ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, L.ADDRESS1
, L.ADDRESS2
, L.ADDRESS3
, L.ADDRESS4
, L.CITY
, L.COUNTY
, L.STATE
, L.PROVINCE
, L.POSTAL_CODE
, NULL
, L.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 300
, 1
, 1) DESCRIPTION
, CA.ORG_ID ORG_ID
, NULL PRIMARY_UOM_CODE
, PS.ADDRESSEE ADDRESSEE
FROM HZ_PARTY_SITES PS
, HZ_LOCATIONS L
, HZ_CUST_ACCT_SITES_ALL CA
WHERE L.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND PS.LOCATION_ID = L.LOCATION_ID
AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID

Columns

Name
ID1
ID2
CUST_ACCT_SITE_ID
CUST_ACCOUNT_ID
PARTY_SITE_ID
PARTY_ID
PARTY_SITE_NAME
STATUS
LOCATION_ID
NAME
COUNTRY
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
POSTAL_CODE
STATE
PROVINCE
COUNTY
LOCATION_DESCRIPTION
DESCRIPTION
ORG_ID
PRIMARY_UOM_CODE
ADDRESSEE