PER_LOC_ADDRESS_USAGES

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
LOC_ADDRESS_USAGE_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE OBJECT_VERSION_NUMBER BUSINESS_GROUP_ID ADDRESS_USAGE_TYPE LOCATION_ID ADDRESS_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

LOC_ADDRESS_USAGE_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

OBJECT_VERSION_NUMBER

BUSINESS_GROUP_ID

ADDRESS_USAGE_TYPE

LOCATION_ID

ADDRESS_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
( SELECT "LOC_ADDRESS_USAGE_ID","EFFECTIVE_START_DATE","EFFECTIVE_END_DATE","OBJECT_VERSION_NUMBER","BUSINESS_GROUP_ID","ADDRESS_USAGE_TYPE","LOCATION_ID","ADDRESS_ID","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN" FROM per_loc_address_usages_f WHERE TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date )

SQL_Statement

(

SELECT "LOC_ADDRESS_USAGE_ID","EFFECTIVE_START_DATE","EFFECTIVE_END_DATE","OBJECT_VERSION_NUMBER","BUSINESS_GROUP_ID","ADDRESS_USAGE_TYPE","LOCATION_ID","ADDRESS_ID","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN"

FROM per_loc_address_usages_f

WHERE TRUNC(SYSDATE)

BETWEEN effective_start_date AND effective_end_date )