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.XNB_PRIMARY_BILL_TO_ADDR_V

Source

View Text - Preformatted


SELECT PARTY_ACCT_SITES.CUST_ACCOUNT_ID CUST_ACCOUNT_ID, PARTY_SITE_USES.ORG_ID ORG_ID, LOCATIONS.ADDRESS1||DECODE(LOCATIONS.ADDRESS2 , NULL , NULL , ';'||LOCATIONS.ADDRESS2|| DECODE(LOCATIONS.ADDRESS3 , NULL , NULL , ';'||LOCATIONS.ADDRESS3|| DECODE(LOCATIONS.ADDRESS4 , NULL , NULL , ';'||LOCATIONS.ADDRESS4))) PRIMARY_BILL_TO_ADDRESS, LOCATIONS.COUNTRY PRIMARY_BILL_TO_COUNTRY, LOCATIONS.STATE PRIMARY_BILL_TO_STATE, LOCATIONS.COUNTY PRIMARY_BILL_TO_COUNTY, LOCATIONS.CITY PRIMARY_BILL_TO_CITY, LOCATIONS.POSTAL_CODE PRIMARY_BILL_TO_POSTAL_CODE from HZ_PARTY_SITES PARTY_SITES, HZ_LOCATIONS LOCATIONS, HZ_CUST_SITE_USES_ALL PARTY_SITE_USES, HZ_CUST_ACCT_SITES_ALL PARTY_ACCT_SITES WHERE PARTY_SITE_USES.SITE_USE_CODE = 'BILL_TO' AND PARTY_SITE_USES.PRIMARY_FLAG = 'Y' AND PARTY_SITE_USES.STATUS = 'A' AND PARTY_SITE_USES.CUST_ACCT_SITE_ID = PARTY_ACCT_SITES.CUST_ACCT_SITE_ID AND PARTY_ACCT_SITES.STATUS = 'A' AND PARTY_ACCT_SITES.PARTY_SITE_ID = PARTY_SITES.PARTY_SITE_ID AND PARTY_SITES.LOCATION_ID = LOCATIONS.LOCATION_ID

View Text - HTML Formatted

SELECT PARTY_ACCT_SITES.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PARTY_SITE_USES.ORG_ID ORG_ID
, LOCATIONS.ADDRESS1||DECODE(LOCATIONS.ADDRESS2
, NULL
, NULL
, ';'||LOCATIONS.ADDRESS2|| DECODE(LOCATIONS.ADDRESS3
, NULL
, NULL
, ';'||LOCATIONS.ADDRESS3|| DECODE(LOCATIONS.ADDRESS4
, NULL
, NULL
, ';'||LOCATIONS.ADDRESS4))) PRIMARY_BILL_TO_ADDRESS
, LOCATIONS.COUNTRY PRIMARY_BILL_TO_COUNTRY
, LOCATIONS.STATE PRIMARY_BILL_TO_STATE
, LOCATIONS.COUNTY PRIMARY_BILL_TO_COUNTY
, LOCATIONS.CITY PRIMARY_BILL_TO_CITY
, LOCATIONS.POSTAL_CODE PRIMARY_BILL_TO_POSTAL_CODE
FROM HZ_PARTY_SITES PARTY_SITES
, HZ_LOCATIONS LOCATIONS
, HZ_CUST_SITE_USES_ALL PARTY_SITE_USES
, HZ_CUST_ACCT_SITES_ALL PARTY_ACCT_SITES
WHERE PARTY_SITE_USES.SITE_USE_CODE = 'BILL_TO'
AND PARTY_SITE_USES.PRIMARY_FLAG = 'Y'
AND PARTY_SITE_USES.STATUS = 'A'
AND PARTY_SITE_USES.CUST_ACCT_SITE_ID = PARTY_ACCT_SITES.CUST_ACCT_SITE_ID
AND PARTY_ACCT_SITES.STATUS = 'A'
AND PARTY_ACCT_SITES.PARTY_SITE_ID = PARTY_SITES.PARTY_SITE_ID
AND PARTY_SITES.LOCATION_ID = LOCATIONS.LOCATION_ID