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.

VIEW: APPS.OKI_HBILLTO_DTL_V

Source

View Text - Preformatted


SELECT SU.SITE_USE_ID BILL_SITE_ID , CAC.ACCOUNT_NAME || ' / ' || HZ.PARTY_NAME BILL_TO_PARTY_ACCOUNT , SU.LOCATION BILL_TO_LOCATION , HL.ADDRESS1 BILL_TO_ADDRESS1 , HL.ADDRESS2 BILL_TO_ADDRESS2 , HL.ADDRESS3 BILL_TO_ADDRESS3 , HL.CITY BILL_TO_CITY , HL.POSTAL_CODE BILL_TO_POSTAL_CODE , HL.STATE BILL_TO_STATE , HL.COUNTRY BILL_TO_COUNTRY FROM HZ_CUST_ACCT_SITES_ALL CAS , HZ_CUST_ACCOUNTS CAC , HZ_LOCATIONS HL , HZ_PARTY_SITES PS , HZ_PARTIES HZ , HZ_CUST_SITE_USES_ALL SU WHERE CAS.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID AND CAC.CUST_ACCOUNT_ID = CAS.CUST_ACCOUNT_ID AND HZ.PARTY_ID = CAC.PARTY_ID AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID AND HL.LOCATION_ID = PS.LOCATION_ID

View Text - HTML Formatted

SELECT SU.SITE_USE_ID BILL_SITE_ID
, CAC.ACCOUNT_NAME || ' / ' || HZ.PARTY_NAME BILL_TO_PARTY_ACCOUNT
, SU.LOCATION BILL_TO_LOCATION
, HL.ADDRESS1 BILL_TO_ADDRESS1
, HL.ADDRESS2 BILL_TO_ADDRESS2
, HL.ADDRESS3 BILL_TO_ADDRESS3
, HL.CITY BILL_TO_CITY
, HL.POSTAL_CODE BILL_TO_POSTAL_CODE
, HL.STATE BILL_TO_STATE
, HL.COUNTRY BILL_TO_COUNTRY
FROM HZ_CUST_ACCT_SITES_ALL CAS
, HZ_CUST_ACCOUNTS CAC
, HZ_LOCATIONS HL
, HZ_PARTY_SITES PS
, HZ_PARTIES HZ
, HZ_CUST_SITE_USES_ALL SU
WHERE CAS.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
AND CAC.CUST_ACCOUNT_ID = CAS.CUST_ACCOUNT_ID
AND HZ.PARTY_ID = CAC.PARTY_ID
AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
AND HL.LOCATION_ID = PS.LOCATION_ID