eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MSC_ITEM_SUPPLIER_CAPACITY_V

Source

View Text - Preformatted


SELECT MscItemSuppliersEO.PLAN_ID, MscItemSuppliersEO.sr_instance_id, MscItemSuppliersEO.organization_id, MscItemSuppliersEO.INVENTORY_ITEM_ID, MscItemSuppliersEO.SUPPLIER_ID, MscItemSuppliersEO.SUPPLIER_SITE_ID, MscItemSuppliersEO.USING_ORGANIZATION_ID , MscItemSuppliersEO.SR_INSTANCE_ID2 , MscSupplierCapacitiesEO.transaction_id, MscItemSuppliersEO.FIXED_LOT_MULTIPLIER , MscItemSuppliersEO.ITEM_PRICE AS Supplier_Price, msc_get_name.supplier(MscItemSuppliersEO.SUPPLIER_ID) AS Supplier, MscItemSuppliersEO.DESCRIPTION AS Supplier_Description, msc_get_name.supplier_site(MscItemSuppliersEO.SUPPLIER_site_ID) AS Supplier_Site, MscItemSuppliersEO.DELIVERY_CALENDAR_CODE AS Delivery_Calendar_Code, DECODE(SIGN(MscItemSuppliersEO.LAST_UPDATE_DATE - NVL(MscSupplierCapacitiesEO.LAST_UPDATE_DATE, MscItemSuppliersEO.LAST_UPDATE_DATE)), -1, MscSupplierCapacitiesEO.LAST_UPDATE_DATE, MscItemSuppliersEO.LAST_UPDATE_DATE) AS Last_Updated_Date, MscSystemItems.ITEM_NAME AS Item, MscSystemItems.DESCRIPTION AS Item_Description, MscSystemItems.CATEGORY_NAME AS Item_Category, MscItemSuppliersEO.PROCESSING_LEAD_TIME AS Processing_Lead_Time, MscSystemItems.BUYER_NAME AS Buyer, MscSystemItems.PLANNER_CODE AS Planner, MscItemSuppliersEO.MINIMUM_ORDER_QUANTITY AS Minimum_Order_Quantity, MscItemSuppliersEO.SUPPLIER_LEAD_TIME_DATE AS Capacity_Accumulation_Date, MscSupplierCapacitiesEO.FROM_DATE AS From_Date, MscSupplierCapacitiesEO.TO_DATE AS To_Date, MscSupplierCapacitiesEO.CAPACITY AS Capacity, FND_CONC_REQUEST_PKG.get_user_name(DECODE(SIGN(MscItemSuppliersEO.LAST_UPDATE_DATE - NVL(MscSupplierCapacitiesEO.LAST_UPDATE_DATE, MscItemSuppliersEO.LAST_UPDATE_DATE)), -1, MscSupplierCapacitiesEO.LAST_UPDATED_BY, MscItemSuppliersEO.LAST_UPDATED_BY)) AS LAST_UPDATER, MscItemSuppliersEO.SIMULATION_SET_ID as supplier_sim_set_id, MscItemSuppliersEO.NEW_PLAN_ID as supplier_new_plan_id, MscItemSuppliersEO.NEW_PLAN_LIST as supplier_new_plan_list, MscItemSuppliersEO.applied as supplier_applied, MscSupplierCapacitiesEO.SIMULATION_SET_ID as capacity_sim_set_id, MscSupplierCapacitiesEO.NEW_PLAN_ID as capacity_new_plan_id, MscSupplierCapacitiesEO.NEW_PLAN_LIST as capacity_new_plan_list, MscSupplierCapacitiesEO.applied as capacity_applied, MscSystemItems.new_plan_id as item_new_plan_id, MscSystemItems.new_plan_list as item_new_plan_list, MscSystemItems.simulation_set_id as item_sim_set_id, MscSystemItems.applied as item_applied FROM MSC_ITEM_SUPPLIERS MscItemSuppliersEO, MSC_SUPPLIER_CAPACITIES MscSupplierCapacitiesEO, MSC_SYSTEM_ITEMS MscSystemItems where MscItemSuppliersEO.PLAN_ID = MscSupplierCapacitiesEO.PLAN_ID(+) AND MscItemSuppliersEO.SR_INSTANCE_ID = MscSupplierCapacitiesEO.SR_INSTANCE_ID(+) AND MscItemSuppliersEO.ORGANIZATION_ID = MscSupplierCapacitiesEO.ORGANIZATION_ID(+) AND MscItemSuppliersEO.SUPPLIER_ID = MscSupplierCapacitiesEO.SUPPLIER_ID(+) AND nvl(MscItemSuppliersEO.SUPPLIER_SITE_ID,-1) = nvl(MscSupplierCapacitiesEO.SUPPLIER_SITE_ID(+),-1) AND MscItemSuppliersEO.INVENTORY_ITEM_ID = MscSupplierCapacitiesEO.INVENTORY_ITEM_ID(+) AND nvl(MscItemSuppliersEO.simulation_set_id,-1) = nvl(MscSupplierCapacitiesEO.simulation_set_id(+),-1) AND MscItemSuppliersEO.USING_ORGANIZATION_ID = MscSupplierCapacitiesEO.USING_ORGANIZATION_ID(+) AND MscItemSuppliersEO.ORGANIZATION_ID = MscSystemItems.ORGANIZATION_ID AND MscItemSuppliersEO.SR_INSTANCE_ID = MscSystemItems.SR_INSTANCE_ID AND MscItemSuppliersEO.INVENTORY_ITEM_ID = MscSystemItems.INVENTORY_ITEM_ID and ( (MscItemSuppliersEO.simulation_set_id is null and MscItemSuppliersEO.plan_id=MscSystemItems.plan_id) OR (MscSystemItems.plan_id=-1 and MscItemSuppliersEO.simulation_set_id is not null) ) AND MscSystemItems.NEW_PLAN_ID is null AND MscSystemItems.SIMULATION_SET_ID is null

View Text - HTML Formatted

SELECT MSCITEMSUPPLIERSEO.PLAN_ID
, MSCITEMSUPPLIERSEO.SR_INSTANCE_ID
, MSCITEMSUPPLIERSEO.ORGANIZATION_ID
, MSCITEMSUPPLIERSEO.INVENTORY_ITEM_ID
, MSCITEMSUPPLIERSEO.SUPPLIER_ID
, MSCITEMSUPPLIERSEO.SUPPLIER_SITE_ID
, MSCITEMSUPPLIERSEO.USING_ORGANIZATION_ID
, MSCITEMSUPPLIERSEO.SR_INSTANCE_ID2
, MSCSUPPLIERCAPACITIESEO.TRANSACTION_ID
, MSCITEMSUPPLIERSEO.FIXED_LOT_MULTIPLIER
, MSCITEMSUPPLIERSEO.ITEM_PRICE AS SUPPLIER_PRICE
, MSC_GET_NAME.SUPPLIER(MSCITEMSUPPLIERSEO.SUPPLIER_ID) AS SUPPLIER
, MSCITEMSUPPLIERSEO.DESCRIPTION AS SUPPLIER_DESCRIPTION
, MSC_GET_NAME.SUPPLIER_SITE(MSCITEMSUPPLIERSEO.SUPPLIER_SITE_ID) AS SUPPLIER_SITE
, MSCITEMSUPPLIERSEO.DELIVERY_CALENDAR_CODE AS DELIVERY_CALENDAR_CODE
, DECODE(SIGN(MSCITEMSUPPLIERSEO.LAST_UPDATE_DATE - NVL(MSCSUPPLIERCAPACITIESEO.LAST_UPDATE_DATE
, MSCITEMSUPPLIERSEO.LAST_UPDATE_DATE))
, -1
, MSCSUPPLIERCAPACITIESEO.LAST_UPDATE_DATE
, MSCITEMSUPPLIERSEO.LAST_UPDATE_DATE) AS LAST_UPDATED_DATE
, MSCSYSTEMITEMS.ITEM_NAME AS ITEM
, MSCSYSTEMITEMS.DESCRIPTION AS ITEM_DESCRIPTION
, MSCSYSTEMITEMS.CATEGORY_NAME AS ITEM_CATEGORY
, MSCITEMSUPPLIERSEO.PROCESSING_LEAD_TIME AS PROCESSING_LEAD_TIME
, MSCSYSTEMITEMS.BUYER_NAME AS BUYER
, MSCSYSTEMITEMS.PLANNER_CODE AS PLANNER
, MSCITEMSUPPLIERSEO.MINIMUM_ORDER_QUANTITY AS MINIMUM_ORDER_QUANTITY
, MSCITEMSUPPLIERSEO.SUPPLIER_LEAD_TIME_DATE AS CAPACITY_ACCUMULATION_DATE
, MSCSUPPLIERCAPACITIESEO.FROM_DATE AS FROM_DATE
, MSCSUPPLIERCAPACITIESEO.TO_DATE AS TO_DATE
, MSCSUPPLIERCAPACITIESEO.CAPACITY AS CAPACITY
, FND_CONC_REQUEST_PKG.GET_USER_NAME(DECODE(SIGN(MSCITEMSUPPLIERSEO.LAST_UPDATE_DATE - NVL(MSCSUPPLIERCAPACITIESEO.LAST_UPDATE_DATE
, MSCITEMSUPPLIERSEO.LAST_UPDATE_DATE))
, -1
, MSCSUPPLIERCAPACITIESEO.LAST_UPDATED_BY
, MSCITEMSUPPLIERSEO.LAST_UPDATED_BY)) AS LAST_UPDATER
, MSCITEMSUPPLIERSEO.SIMULATION_SET_ID AS SUPPLIER_SIM_SET_ID
, MSCITEMSUPPLIERSEO.NEW_PLAN_ID AS SUPPLIER_NEW_PLAN_ID
, MSCITEMSUPPLIERSEO.NEW_PLAN_LIST AS SUPPLIER_NEW_PLAN_LIST
, MSCITEMSUPPLIERSEO.APPLIED AS SUPPLIER_APPLIED
, MSCSUPPLIERCAPACITIESEO.SIMULATION_SET_ID AS CAPACITY_SIM_SET_ID
, MSCSUPPLIERCAPACITIESEO.NEW_PLAN_ID AS CAPACITY_NEW_PLAN_ID
, MSCSUPPLIERCAPACITIESEO.NEW_PLAN_LIST AS CAPACITY_NEW_PLAN_LIST
, MSCSUPPLIERCAPACITIESEO.APPLIED AS CAPACITY_APPLIED
, MSCSYSTEMITEMS.NEW_PLAN_ID AS ITEM_NEW_PLAN_ID
, MSCSYSTEMITEMS.NEW_PLAN_LIST AS ITEM_NEW_PLAN_LIST
, MSCSYSTEMITEMS.SIMULATION_SET_ID AS ITEM_SIM_SET_ID
, MSCSYSTEMITEMS.APPLIED AS ITEM_APPLIED
FROM MSC_ITEM_SUPPLIERS MSCITEMSUPPLIERSEO
, MSC_SUPPLIER_CAPACITIES MSCSUPPLIERCAPACITIESEO
, MSC_SYSTEM_ITEMS MSCSYSTEMITEMS
WHERE MSCITEMSUPPLIERSEO.PLAN_ID = MSCSUPPLIERCAPACITIESEO.PLAN_ID(+)
AND MSCITEMSUPPLIERSEO.SR_INSTANCE_ID = MSCSUPPLIERCAPACITIESEO.SR_INSTANCE_ID(+)
AND MSCITEMSUPPLIERSEO.ORGANIZATION_ID = MSCSUPPLIERCAPACITIESEO.ORGANIZATION_ID(+)
AND MSCITEMSUPPLIERSEO.SUPPLIER_ID = MSCSUPPLIERCAPACITIESEO.SUPPLIER_ID(+)
AND NVL(MSCITEMSUPPLIERSEO.SUPPLIER_SITE_ID
, -1) = NVL(MSCSUPPLIERCAPACITIESEO.SUPPLIER_SITE_ID(+)
, -1)
AND MSCITEMSUPPLIERSEO.INVENTORY_ITEM_ID = MSCSUPPLIERCAPACITIESEO.INVENTORY_ITEM_ID(+)
AND NVL(MSCITEMSUPPLIERSEO.SIMULATION_SET_ID
, -1) = NVL(MSCSUPPLIERCAPACITIESEO.SIMULATION_SET_ID(+)
, -1)
AND MSCITEMSUPPLIERSEO.USING_ORGANIZATION_ID = MSCSUPPLIERCAPACITIESEO.USING_ORGANIZATION_ID(+)
AND MSCITEMSUPPLIERSEO.ORGANIZATION_ID = MSCSYSTEMITEMS.ORGANIZATION_ID
AND MSCITEMSUPPLIERSEO.SR_INSTANCE_ID = MSCSYSTEMITEMS.SR_INSTANCE_ID
AND MSCITEMSUPPLIERSEO.INVENTORY_ITEM_ID = MSCSYSTEMITEMS.INVENTORY_ITEM_ID
AND ( (MSCITEMSUPPLIERSEO.SIMULATION_SET_ID IS NULL
AND MSCITEMSUPPLIERSEO.PLAN_ID=MSCSYSTEMITEMS.PLAN_ID) OR (MSCSYSTEMITEMS.PLAN_ID=-1
AND MSCITEMSUPPLIERSEO.SIMULATION_SET_ID IS NOT NULL) )
AND MSCSYSTEMITEMS.NEW_PLAN_ID IS NULL
AND MSCSYSTEMITEMS.SIMULATION_SET_ID IS NULL