MSC_PRICE_LISTS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PRICE_LIST_ID PRICE_LIST_NAME PRICE_LIST_DESCRIPTION PRICE_LIST_START_DATE PRICE_LIST_END_DATE REFRESH_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT MPL.PRICE_LIST_ID PRICE_LIST_ID , MPL.PRICE_LIST_NAME PRICE_LIST_NAME , MPL.PRICE_LIST_DESCRIPTION PRICE_LIST_DESCRIPTION, MPL.PRICE_LIST_START_DATE PRICE_LIST_START_DATE , MPL.PRICE_LIST_END_DATE PRICE_LIST_END_DATE , MPL.REFRESH_NUMBER REFRESH_NUMBER , MPL.LAST_UPDATE_DATE LAST_UPDATE_DATE , MPL.LAST_UPDATED_BY LAST_UPDATED_BY , MPL.CREATION_DATE CREATION_DATE , MPL.CREATED_BY CREATED_BY , MPL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM MSC_PRICE_LISTS MPL UNION ALL SELECT TO_NUMBER(FLV.LOOKUP_CODE) PRICE_LIST_ID , FLV.MEANING PRICE_LIST_NAME , FLV.DESCRIPTION PRICE_LIST_DESCRIPTION, -1 PRICE_LIST_START_DATE , -1 PRICE_LIST_END_DATE , -1 REFRESH_NUMBER , FLV.LAST_UPDATE_DATE LAST_UPDATE_DATE , FLV.LAST_UPDATED_BY LAST_UPDATED_BY , FLV.CREATION_DATE CREATION_DATE , FLV.CREATED_BY CREATED_BY , FLV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM FND_LOOKUP_VALUES_VL FLV WHERE FLV.LOOKUP_TYPE = 'ORA_MSC_PRICE_LISTS'