ECC Inventory Management, Inventory Supply and Demand

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: inv-sup-dmd
Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
x.*
from
(
SELECT * FROM (SELECT
                                                       IESD.ECC_SPEC_ID,
                                                       IESD.ECC_SPEC_ID ORG_ITEM_SD,
                                                       IESD.ORGANIZATION_CODE,
                                                       IESD.ORGANIZATION_ID,
                                                       IESD.INVENTORY_ITEM_ID,
                                                       IESD.ITEM_NAME,
                                                       IESD.ITEM_DESCRIPTION,
                                                       IESD.REQUIREMENT_DATE,
                                                       IESD.SUPPLY_DEMAND_SOURCE_TYPE,
                                                       Decode(IESD.SUPPLY_DEMAND_SOURCE_TYPE,9,2,21,8,22,8,23,2, IESD.SUPPLY_DEMAND_SOURCE_TYPE) DEMAND_SOURCE_TYPE,
                                                       IESD.SUPPLY_DEMAND_TYPE,
                                                       IESD.SUPPLY_DEMAND_ID,
                                                       IESD.SUPPLY_DEMAND_VALUE,
                                                       IESD.SUPPLY_DEMAND_SOURCE,
                                                       IESD.QUANTITY,
                                                       IESD.ONHAND_QUANTITY,
                                                       IESD.NET_CHANGE,
                                                       IESD.TOTAL_SUPPLY,
                                                       IESD.TOTAL_DEMAND,
                                                       IESD.NET_AVAILABLE,
                                                       IESD.ABS_QUANTITY,
                                                       IESD.EXCESS_DEMAND,
                                                       decode(IESD.SUPPLY_DEMAND,'AVAILABLE',
                                                              (SELECT meaning
                                                                FROM fnd_lookup_values flv
                                                               WHERE lookup_code = IESD.SUPPLY_DEMAND
                                                                 AND lookup_type = 'OKR_R_AVAIL_STATUS'
                                                                 AND view_application_id=0
                                                                 AND flv.language= IESD.language),
                                                              (SELECT meaning
                                                                FROM fnd_lookup_values flv
                                                               WHERE lookup_code = IESD.SUPPLY_DEMAND
                                                                 AND lookup_type = 'MRP_SUPPLY_DEMAND_TYPE'
                                                                 AND view_application_id=700
                                                                 AND flv.language= IESD.language)) SUPPLY_DEMAND,
                                                       IESD.SUPPLY_STATUS SUPPLY_STATUS_CODE,
                                                       decode(IESD.SUPPLY_STATUS, null, null,
                                                              (SELECT meaning
                                                                FROM fnd_lookup_values flv
                                                               WHERE lookup_code = IESD.SUPPLY_STATUS
                                                                 AND lookup_type = 'INV_ECC_SUPPLY_DEMAND_STATUS'
                                                                 AND view_application_id=3
                                                                 AND flv.language= IESD.language)) SUPPLY_STATUS,
                                                       IESD.DEMAND_STATUS DEMAND_STATUS_CODE,
                                                       decode(IESD.DEMAND_STATUS, null, null,
                                                              (SELECT meaning
                                                                FROM fnd_lookup_values flv
                                                               WHERE lookup_code = IESD.DEMAND_STATUS
                                                                 AND lookup_type = 'INV_ECC_SUPPLY_DEMAND_STATUS'
                                                                 AND view_application_id=3
                                                                 AND flv.language= IESD.language)) DEMAND_STATUS,
                                                       IESD.DATE_MONTH,
                                                       IESD.EXCESS_STOCK,
                                                       IESD.DAILY_NET_AVAILABLE,
                                                       IESD.PHYSICAL_ONHAND,
                                                       IESD.PHYSICAL_AVAILABILITY,
                                                       IESD.LANGUAGE , DECODE (IESD.INVENTORY_ITEM_ID, NULL ,'N', DECODE (IESD.SUPPLY_DEMAND_SOURCE_TYPE, 9,'Y', 22, 'Y', 'N' )) ALLOW_TRANSFER_RESERVATION , DECODE (IESD.INVENTORY_ITEM_ID, NULL ,'N', 'Y') ALLOW_VIEW_ONHAND FROM INV_ECC_SUP_DMD_V IESD WHERE LANGUAGE IN ( 'US') AND IESD.PROCESS_FLAG=1 )PIVOT (MAX(ITEM_DESCRIPTION) AS ITEM_DESCRIPTION, Max(SUPPLY_STATUS) AS SUPPLY_STATUS,Max(DEMAND_STATUS) AS DEMAND_STATUS,Max(SUPPLY_DEMAND) AS SUPPLY_DEMAND for LANGUAGE in ( 'US' "US")) 
) x
where
2=2
Parameter Name SQL text Validation
Organization Code
x.organization_code=:organization_code
LOV