DBA Data[Home] [Help]

VIEW: APPS.OKX_CUST_SITE_USES_V

Source

View Text - Preformatted

SELECT CS.SITE_USE_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, CS.SITE_USE_CODE SITE_USE_CODE, CS.STATUS B_STATUS, CS.STATUS STATUS, CA.STATUS CUST_ACCT_SITE_STATUS, L.LOCATION_ID LOCATION_ID, CS.LOCATION 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, PS.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS_FLAG, 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',800,1,1) DESCRIPTION, CS.ORG_ID ORG_ID, NULL PRIMARY_UOM_CODE, CS.PAYMENT_TERM_ID FROM HZ_CUST_SITE_USES CS,HZ_PARTY_SITES PS,HZ_LOCATIONS L,HZ_CUST_ACCT_SITES_ALL CA WHERE PS.LOCATION_ID = L.LOCATION_ID AND L.CONTENT_SOURCE_TYPE = 'USER_ENTERED' AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
View Text - HTML Formatted

SELECT CS.SITE_USE_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
, CS.SITE_USE_CODE SITE_USE_CODE
, CS.STATUS B_STATUS
, CS.STATUS STATUS
, CA.STATUS CUST_ACCT_SITE_STATUS
, L.LOCATION_ID LOCATION_ID
, CS.LOCATION 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
, PS.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS_FLAG
, 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'
, 800
, 1
, 1) DESCRIPTION
, CS.ORG_ID ORG_ID
, NULL PRIMARY_UOM_CODE
, CS.PAYMENT_TERM_ID
FROM HZ_CUST_SITE_USES CS
, HZ_PARTY_SITES PS
, HZ_LOCATIONS L
, HZ_CUST_ACCT_SITES_ALL CA
WHERE PS.LOCATION_ID = L.LOCATION_ID
AND L.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID