VIEW: APPS.OKL_LA_BILL_TO_UV

Source

View Text - Preformatted

SELECT site_use.ID1 ID1, site_use.ID2 ID2, site_use.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID, site_use.CUST_ACCOUNT_ID CUST_ACCOUNT_ID, site_use.PARTY_SITE_ID PARTY_SITE_ID, site_use.PARTY_ID PARTY_ID, site_use.PARTY_SITE_NAME PARTY_SITE_NAME, site_use.SITE_USE_CODE SITE_USE_CODE, site_use.B_STATUS B_STATUS, site_use.NAME NAME, site_use.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS_FLAG, NULL START_DATE_ACTIVE, NULL END_DATE_ACTIVE, site_use.DESCRIPTION DESCRIPTION, site_use.ORG_ID ORG_ID, site.status ACCT_SITE_STATUS FROM OKX_CUST_SITE_USES_V SITE_USE,HZ_CUST_ACCT_SITES_ALL SITE WHERE site.cust_acct_site_id = site_use.cust_acct_site_id and site_use.site_use_code = 'BILL_TO'

View Text - HTML Formatted

SELECT SITE_USE.ID1 ID1
, SITE_USE.ID2 ID2
, SITE_USE.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, SITE_USE.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, SITE_USE.PARTY_SITE_ID PARTY_SITE_ID
, SITE_USE.PARTY_ID PARTY_ID
, SITE_USE.PARTY_SITE_NAME PARTY_SITE_NAME
, SITE_USE.SITE_USE_CODE SITE_USE_CODE
, SITE_USE.B_STATUS B_STATUS
, SITE_USE.NAME NAME
, SITE_USE.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS_FLAG
, NULL START_DATE_ACTIVE
, NULL END_DATE_ACTIVE
, SITE_USE.DESCRIPTION DESCRIPTION
, SITE_USE.ORG_ID ORG_ID
, SITE.STATUS ACCT_SITE_STATUS
FROM OKX_CUST_SITE_USES_V SITE_USE
, HZ_CUST_ACCT_SITES_ALL SITE
WHERE SITE.CUST_ACCT_SITE_ID = SITE_USE.CUST_ACCT_SITE_ID
AND SITE_USE.SITE_USE_CODE = 'BILL_TO'