MSC_PRICE_LIST_DATA_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PLAN_ID PRICE_LIST_ID PRD_LVL_MEMBER_ID ORG_LVL_MEMBER_ID PRICE_START_DATE PRICE_END_DATE PRICE PRICE_CURRENCY PRICE_UOM

Query

SQL_Statement

SELECT PLAN_ID, PRICE_LIST_ID, INVENTORY_ITEM_ID PRD_LVL_MEMBER_ID, ORGANIZATION_ID ORG_LVL_MEMBER_ID, decode(ITEM_PRICE_START_DATE, -1, NULL, ITEM_PRICE_START_DATE) PRICE_START_DATE, decode(ITEM_PRICE_END_DATE, -1, NULL, ITEM_PRICE_END_DATE) PRICE_END_DATE, PRICE, PRICE_CURRENCY, PRICE_UOM FROM MSC_PRICE_LIST_DETAILS UNION ALL SELECT LPD.PLAN_ID, -1 PRICE_LIST_ID, LPD.INVENTORY_ITEM_ID PRD_LVL_MEMBER_ID, LPD.ORGANIZATION_ID ORG_LVL_MEMBER_ID, NULL PRICE_START_DATE, NULL PRICE_END_DATE, LPD.LIST_PRICE PRICE, 'USD' PRICE_CURRENCY, LPD.UOM_CODE PRICE_UOM FROM MSC_SYSTEM_ITEMS LPD WHERE LPD.list_price is not null