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: OKL_LA_BILL_TO_UV

Product:	OKL - Lease and Finance Management
Description:	View for BILL_TO LOV
Implementation/DBA Data:	APPS.OKL_LA_BILL_TO_UV

View Text

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'

Columns

Name
ID1
ID2
CUST_ACCT_SITE_ID
CUST_ACCOUNT_ID
PARTY_SITE_ID
PARTY_ID
PARTY_SITE_NAME
SITE_USE_CODE
B_STATUS
NAME
IDENTIFYING_ADDRESS_FLAG
START_DATE_ACTIVE
END_DATE_ACTIVE
DESCRIPTION
ORG_ID
ACCT_SITE_STATUS