View: ARBV_LOCATIONS

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.ARBV_LOCATIONS

View Text

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

Columns