VIEW: APPS.AMS_CAMPAIGN_PRODUCT_VOLUMES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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