VIEW: APPS.IGSFV_LOCATIONS

Source

View Text - Preformatted

SELECT LOC.LOCATION_CD LOCATION_CODE, LOC.DESCRIPTION, LOC.LOCATION_TYPE, LOC.MAIL_DLVRY_WRK_DAYS MAIL_DELIVERY_WORKING_DAYS, LOC.CLOSED_IND CLOSED_INDICATOR, LOC.REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE, '_DF:IGS:IGS_OR_LOC_FLEX:LOC', LOT.DESCRIPTION LOCATION_TYPE_DESC, '_LA:LOT.S_LOCATION_TYPE:IGS_LOOKUP_VALUES:LOCATION_TYPE:MEANING', HP.PARTY_NUMBER COORDINATE_PERSON_NUMBER, ACC.DESCRIPTION REVENUE_ACCOUNT_DESC, LOC.COORD_PERSON_ID COORDINATE_PERSON_ID, LOC.CREATED_BY, LOC.CREATION_DATE, LOC.LAST_UPDATED_BY, LOC.LAST_UPDATE_DATE FROM IGS_AD_LOCATION_ALL LOC, HZ_PARTIES HP, IGS_AD_LOCATION_TYPE_ALL LOT, IGS_FI_ACC_ALL ACC WHERE LOC.COORD_PERSON_ID = HP.PARTY_ID(+) AND LOC.LOCATION_TYPE = LOT.LOCATION_TYPE AND LOC.REV_ACCOUNT_CD = ACC.ACCOUNT_CD(+) WITH READ ONLY

View Text - HTML Formatted

SELECT LOC.LOCATION_CD LOCATION_CODE
, LOC.DESCRIPTION
, LOC.LOCATION_TYPE
, LOC.MAIL_DLVRY_WRK_DAYS MAIL_DELIVERY_WORKING_DAYS
, LOC.CLOSED_IND CLOSED_INDICATOR
, LOC.REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE
, '_DF:IGS:IGS_OR_LOC_FLEX:LOC'
, LOT.DESCRIPTION LOCATION_TYPE_DESC
, '_LA:LOT.S_LOCATION_TYPE:IGS_LOOKUP_VALUES:LOCATION_TYPE:MEANING'
, HP.PARTY_NUMBER COORDINATE_PERSON_NUMBER
, ACC.DESCRIPTION REVENUE_ACCOUNT_DESC
, LOC.COORD_PERSON_ID COORDINATE_PERSON_ID
, LOC.CREATED_BY
, LOC.CREATION_DATE
, LOC.LAST_UPDATED_BY
, LOC.LAST_UPDATE_DATE
FROM IGS_AD_LOCATION_ALL LOC
, HZ_PARTIES HP
, IGS_AD_LOCATION_TYPE_ALL LOT
, IGS_FI_ACC_ALL ACC
WHERE LOC.COORD_PERSON_ID = HP.PARTY_ID(+)
AND LOC.LOCATION_TYPE = LOT.LOCATION_TYPE
AND LOC.REV_ACCOUNT_CD = ACC.ACCOUNT_CD(+) WITH READ ONLY