Product: | AMS - Marketing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AMS_CAMPAIGN_PRODUCT_VOLUMES_V |
SELECT AP.ACTIVITY_PRODUCT_ID
, AP.OBJECT_VERSION_NUMBER
, AP.MASTER_OBJECT_TYPE
, AP.MASTER_OBJECT_TYPE_MEANING
, AP.MASTER_OBJECT_ID
, AP.LEVEL_TYPE_CODE
, AP.LEVEL_TYPE
, AP.CATEGORY_ID
, AP.CATEGORY_NAME
, AP.CATEGORY_SET_ID
, AP.CATEGORY_SET_NAME
, AP.ORGANIZATION_ID
, AP.INVENTORY_ITEM_ID
, AP.INVENTORY_ITEM_NUMBER
, AP.INVENTORY_ITEM_DESCRIPTION
, ITM.LIST_PRICE_PER_UNIT
, NVL(VOL.BASE_SALES_QUANTITY
, 0) BASE_SALES_QUANTITY
, VOL.BASE_SALES_UOM_CODE
, VOL.PERIOD_ID
, VOL.PERIOD_TYPE
, VOL.ON_DATE
FROM AMS_ACT_PRODUCTS_V AP
, MTL_SYSTEM_ITEMS_VL ITM
, AMS_BASE_SALES_VOL_ALL VOL
WHERE AP.MASTER_OBJECT_TYPE = 'CAMP'
AND AP.INVENTORY_ITEM_ID = ITM.INVENTORY_ITEM_ID
AND AP.ORGANIZATION_ID = ITM.ORGANIZATION_ID
AND VOL.PRODUCT_LEVEL_VALUE(+) = ITM.INVENTORY_ITEM_ID
AND VOL.BASE_SALES_UOM_CODE(+) = ITM.PRIMARY_UOM_CODE