VIEW: APPS.ARBV_LOCATIONS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ PARTY_SITE.PARTY_SITE_ID , /* REGULAR ATTRIBUTES */ '_LA:ADDRA.STATUS:AR_LOOKUPS:CODE_STATUS:MEANING' , LOC.ADDRESS1 || DECODE(LOC.ADDRESS1,NULL,NULL,' ') || LOC.ADDRESS2 || DECODE(LOC.ADDRESS2, NULL,NULL,' ') || LOC.ADDRESS3 || DECODE(LOC.ADDRESS3,NULL,NULL,' ') ||LOC.ADDRESS4 , LOC.CITY , LOC.STATE , LOC.POSTAL_CODE , LOC.PROVINCE , LOC.COUNTRY , ADDRA.ORIG_SYSTEM_REFERENCE , ADDRA.ECE_TP_LOCATION_CODE , '_LA:DECODE(ADDRA.BILL_TO_FLAG,''P'',''Y'',''N''):AR_LOOKUPS:YES/NO:MEANING' , /* IDS */ ADDRA.ORG_ID , ADDRA.CUST_ACCOUNT_ID , LOC.LOCATION_ID , ADDRA.TERRITORY_ID , /* WHO COLUMNS */ ADDRA.LAST_UPDATE_DATE , ADDRA.LAST_UPDATED_BY , ADDRA.CREATION_DATE , ADDRA.CREATED_BY FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ADDRA WHERE ADDRA.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND NVL(ADDRA.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99) AND '_SEC:ADDRA.ORG_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ PARTY_SITE.PARTY_SITE_ID
, /* REGULAR ATTRIBUTES */ '_LA:ADDRA.STATUS:AR_LOOKUPS:CODE_STATUS:MEANING'
, LOC.ADDRESS1 || DECODE(LOC.ADDRESS1
, NULL
, NULL
, ' ') || LOC.ADDRESS2 || DECODE(LOC.ADDRESS2
, NULL
, NULL
, ' ') || LOC.ADDRESS3 || DECODE(LOC.ADDRESS3
, NULL
, NULL
, ' ') ||LOC.ADDRESS4
, LOC.CITY
, LOC.STATE
, LOC.POSTAL_CODE
, LOC.PROVINCE
, LOC.COUNTRY
, ADDRA.ORIG_SYSTEM_REFERENCE
, ADDRA.ECE_TP_LOCATION_CODE
, '_LA:DECODE(ADDRA.BILL_TO_FLAG
, ''P''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, /* IDS */ ADDRA.ORG_ID
, ADDRA.CUST_ACCOUNT_ID
, LOC.LOCATION_ID
, ADDRA.TERRITORY_ID
, /* WHO COLUMNS */ ADDRA.LAST_UPDATE_DATE
, ADDRA.LAST_UPDATED_BY
, ADDRA.CREATION_DATE
, ADDRA.CREATED_BY
FROM HZ_PARTY_SITES PARTY_SITE
, HZ_LOC_ASSIGNMENTS LOC_ASSIGN
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ADDRA
WHERE ADDRA.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
AND NVL(ADDRA.ORG_ID
, -99) = NVL(LOC_ASSIGN.ORG_ID
, -99)
AND '_SEC:ADDRA.ORG_ID' IS NOT NULL WITH READ ONLY