MSC_PRICE_LIST_DATA_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PLAN_ID PRICE_LIST_ID PRD_LVL_MEMBER_ID ORG_LVL_MEMBER_ID PRICE_START_DATE PRICE_END_DATE PRICE PRICE_CURRENCY PRICE_UOM |
問合せ
| 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 |