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.MSD_INCLUDE_EOL_ITEMS_CS_V

Source

View Text - Preformatted


SELECT TO_NUMBER (NULL), MISS.SIMULATION_SET_NAME, D_ORG.LEVEL_PK ORG_LEVEL_VALUE_PK, D_ORG.LEVEL_ID ORG_LEVEL_ID, D_ITM.LEVEL_PK PRD_LEVEL_VALUE_PK, D_ITM.LEVEL_ID PRD_LEVEL_ID, 9 TIME_LEVEL_ID, NULL, NULL, MIA.CREATION_DATE, MIA.CREATED_BY, MIA.LAST_UPDATE_DATE, MIA.LAST_UPDATED_BY, MIA.LAST_UPDATE_LOGIN, 1, 1, 'I', TO_NUMBER(NULL), TO_NUMBER(NULL), D_ITM.SR_LEVEL_PK FROM MSC_ITEM_ATTRIBUTES MIA, MSC_SYSTEM_ITEMS MSI, MSD_LEVEL_VALUES D_ITM, MSD_LEVEL_VALUES D_ORG, MSC_ITEM_SIMULATION_SETS MISS WHERE MIA.PLAN_ID=MSI.PLAN_ID AND MIA.PLAN_ID=-1 AND MISS.SIMULATION_SET_ID=MIA.SIMULATION_SET_ID AND MIA.SR_INSTANCE_ID=MSI.SR_INSTANCE_ID AND MIA.ORGANIZATION_ID=MSI.ORGANIZATION_ID AND MIA.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID AND MIA.EO_FLAG = 1 AND D_ITM.LEVEL_ID =1 AND D_ITM.INSTANCE = TO_CHAR(MSI.SR_INSTANCE_ID) AND D_ITM.SR_LEVEL_PK= TO_CHAR(MSI.SR_INVENTORY_ITEM_ID) AND D_ORG.LEVEL_ID =7 AND D_ORG.INSTANCE = TO_CHAR(MIA.SR_INSTANCE_ID) AND D_ORG.SR_LEVEL_PK= TO_CHAR(MIA.ORGANIZATION_ID) UNION ALL SELECT TO_NUMBER (NULL), MISS.SIMULATION_SET_NAME, D_ORG.LEVEL_PK ORG_LEVEL_VALUE_PK, D_ORG.LEVEL_ID ORG_LEVEL_ID, D_ITM.LEVEL_PK PRD_LEVEL_VALUE_PK, D_ITM.LEVEL_ID PRD_LEVEL_ID, 9 TIME_LEVEL_ID, NULL, NULL, MIS.CREATION_DATE, MIS.CREATED_BY, MIS.LAST_UPDATE_DATE, MIS.LAST_UPDATED_BY, MIS.LAST_UPDATE_LOGIN, 1, 1, 'I', TO_NUMBER(NULL), TO_NUMBER(NULL), D_ITM.SR_LEVEL_PK FROM MSC_ITEM_SUPPLIERS MIS, MSC_SYSTEM_ITEMS MSI, MSD_LEVEL_VALUES D_ITM, MSD_LEVEL_VALUES D_ORG, (select SIMULATION_SET_NAME from MSC_ITEM_SIMULATION_SETS) MISS WHERE MIS.PLAN_ID = -1 AND MIS.PLAN_ID=MSI.PLAN_ID AND MIS.SR_INSTANCE_ID=MSI.SR_INSTANCE_ID AND MIS.ORGANIZATION_ID=MSI.ORGANIZATION_ID AND MIS.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID AND MIS.INCLUDE_LIABILITY_AGREEMENT=1 AND D_ITM.LEVEL_ID =1 AND D_ITM.INSTANCE = TO_CHAR(MSI.SR_INSTANCE_ID) AND D_ITM.SR_LEVEL_PK= TO_CHAR(MSI.SR_INVENTORY_ITEM_ID) AND D_ORG.LEVEL_ID =7 AND D_ORG.INSTANCE = TO_CHAR(MIS.SR_INSTANCE_ID) AND D_ORG.SR_LEVEL_PK= TO_CHAR(MIS.ORGANIZATION_ID) UNION ALL SELECT TO_NUMBER(NULL) PLAN_ID, MCD.CS_NAME CS_NAME, MLV_ORG.LEVEL_PK ORG_LEVEL_VALUE_PK, 7 ORG_LEVEL_ID, MLV_PRD.LEVEL_PK PRD_LEVEL_VALUE_PK, 1 PRD_LEVEL_ID, 9 TIME_LEVEL_ID, TO_NUMBER(MCD.ATTRIBUTE_41) QUANTITY, TO_DATE(MCD.ATTRIBUTE_43,'YYYY/MM/DD'), MCD.CREATION_DATE CREATION_DATE, MCD.CREATED_BY CREATED_BY, MCD.LAST_UPDATE_DATE LAST_UPDATE_DATE, MCD.LAST_UPDATED_BY LAST_UPDATED_BY, MCD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MCD.LAST_REFRESH_NUM LAST_REFRESH_NUM, MCD.CREATED_BY_REFRESH_NUM CREATED_BY_REFRESH_NUM, MCD.ACTION_CODE ACTION_CODE, TO_NUMBER(NULL) PRD_PARENT_LEVEL_ID, TO_NUMBER(NULL) PRD_PARENT_LEVEL_VALUE_PK, MLV_PRD.SR_LEVEL_PK FROM MSD_CS_DATA MCD, MSD_LEVEL_VALUES MLV_ORG, MSD_LEVEL_VALUES MLV_PRD WHERE MCD.CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID FROM MSD_CS_DEFINITIONS WHERE NAME = 'MSD_INCLUDE_EOL_ITEMS') AND MCD.ATTRIBUTE_10 = 7 AND MLV_ORG.LEVEL_ID = 7 AND MCD.ATTRIBUTE_11 = MLV_ORG.SR_LEVEL_PK AND MCD.ATTRIBUTE_1 = MLV_ORG.INSTANCE AND MCD.ATTRIBUTE_2 = 1 AND MLV_PRD.LEVEL_ID = 1 AND MCD.ATTRIBUTE_3 = MLV_PRD.SR_LEVEL_PK AND MCD.ATTRIBUTE_1 = MLV_PRD.INSTANCE

View Text - HTML Formatted

SELECT TO_NUMBER (NULL)
, MISS.SIMULATION_SET_NAME
, D_ORG.LEVEL_PK ORG_LEVEL_VALUE_PK
, D_ORG.LEVEL_ID ORG_LEVEL_ID
, D_ITM.LEVEL_PK PRD_LEVEL_VALUE_PK
, D_ITM.LEVEL_ID PRD_LEVEL_ID
, 9 TIME_LEVEL_ID
, NULL
, NULL
, MIA.CREATION_DATE
, MIA.CREATED_BY
, MIA.LAST_UPDATE_DATE
, MIA.LAST_UPDATED_BY
, MIA.LAST_UPDATE_LOGIN
, 1
, 1
, 'I'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, D_ITM.SR_LEVEL_PK
FROM MSC_ITEM_ATTRIBUTES MIA
, MSC_SYSTEM_ITEMS MSI
, MSD_LEVEL_VALUES D_ITM
, MSD_LEVEL_VALUES D_ORG
, MSC_ITEM_SIMULATION_SETS MISS
WHERE MIA.PLAN_ID=MSI.PLAN_ID
AND MIA.PLAN_ID=-1
AND MISS.SIMULATION_SET_ID=MIA.SIMULATION_SET_ID
AND MIA.SR_INSTANCE_ID=MSI.SR_INSTANCE_ID
AND MIA.ORGANIZATION_ID=MSI.ORGANIZATION_ID
AND MIA.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID
AND MIA.EO_FLAG = 1
AND D_ITM.LEVEL_ID =1
AND D_ITM.INSTANCE = TO_CHAR(MSI.SR_INSTANCE_ID)
AND D_ITM.SR_LEVEL_PK= TO_CHAR(MSI.SR_INVENTORY_ITEM_ID)
AND D_ORG.LEVEL_ID =7
AND D_ORG.INSTANCE = TO_CHAR(MIA.SR_INSTANCE_ID)
AND D_ORG.SR_LEVEL_PK= TO_CHAR(MIA.ORGANIZATION_ID) UNION ALL SELECT TO_NUMBER (NULL)
, MISS.SIMULATION_SET_NAME
, D_ORG.LEVEL_PK ORG_LEVEL_VALUE_PK
, D_ORG.LEVEL_ID ORG_LEVEL_ID
, D_ITM.LEVEL_PK PRD_LEVEL_VALUE_PK
, D_ITM.LEVEL_ID PRD_LEVEL_ID
, 9 TIME_LEVEL_ID
, NULL
, NULL
, MIS.CREATION_DATE
, MIS.CREATED_BY
, MIS.LAST_UPDATE_DATE
, MIS.LAST_UPDATED_BY
, MIS.LAST_UPDATE_LOGIN
, 1
, 1
, 'I'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, D_ITM.SR_LEVEL_PK
FROM MSC_ITEM_SUPPLIERS MIS
, MSC_SYSTEM_ITEMS MSI
, MSD_LEVEL_VALUES D_ITM
, MSD_LEVEL_VALUES D_ORG
, (SELECT SIMULATION_SET_NAME
FROM MSC_ITEM_SIMULATION_SETS) MISS
WHERE MIS.PLAN_ID = -1
AND MIS.PLAN_ID=MSI.PLAN_ID
AND MIS.SR_INSTANCE_ID=MSI.SR_INSTANCE_ID
AND MIS.ORGANIZATION_ID=MSI.ORGANIZATION_ID
AND MIS.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID
AND MIS.INCLUDE_LIABILITY_AGREEMENT=1
AND D_ITM.LEVEL_ID =1
AND D_ITM.INSTANCE = TO_CHAR(MSI.SR_INSTANCE_ID)
AND D_ITM.SR_LEVEL_PK= TO_CHAR(MSI.SR_INVENTORY_ITEM_ID)
AND D_ORG.LEVEL_ID =7
AND D_ORG.INSTANCE = TO_CHAR(MIS.SR_INSTANCE_ID)
AND D_ORG.SR_LEVEL_PK= TO_CHAR(MIS.ORGANIZATION_ID) UNION ALL SELECT TO_NUMBER(NULL) PLAN_ID
, MCD.CS_NAME CS_NAME
, MLV_ORG.LEVEL_PK ORG_LEVEL_VALUE_PK
, 7 ORG_LEVEL_ID
, MLV_PRD.LEVEL_PK PRD_LEVEL_VALUE_PK
, 1 PRD_LEVEL_ID
, 9 TIME_LEVEL_ID
, TO_NUMBER(MCD.ATTRIBUTE_41) QUANTITY
, TO_DATE(MCD.ATTRIBUTE_43
, 'YYYY/MM/DD')
, MCD.CREATION_DATE CREATION_DATE
, MCD.CREATED_BY CREATED_BY
, MCD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MCD.LAST_UPDATED_BY LAST_UPDATED_BY
, MCD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MCD.LAST_REFRESH_NUM LAST_REFRESH_NUM
, MCD.CREATED_BY_REFRESH_NUM CREATED_BY_REFRESH_NUM
, MCD.ACTION_CODE ACTION_CODE
, TO_NUMBER(NULL) PRD_PARENT_LEVEL_ID
, TO_NUMBER(NULL) PRD_PARENT_LEVEL_VALUE_PK
, MLV_PRD.SR_LEVEL_PK
FROM MSD_CS_DATA MCD
, MSD_LEVEL_VALUES MLV_ORG
, MSD_LEVEL_VALUES MLV_PRD
WHERE MCD.CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID
FROM MSD_CS_DEFINITIONS
WHERE NAME = 'MSD_INCLUDE_EOL_ITEMS')
AND MCD.ATTRIBUTE_10 = 7
AND MLV_ORG.LEVEL_ID = 7
AND MCD.ATTRIBUTE_11 = MLV_ORG.SR_LEVEL_PK
AND MCD.ATTRIBUTE_1 = MLV_ORG.INSTANCE
AND MCD.ATTRIBUTE_2 = 1
AND MLV_PRD.LEVEL_ID = 1
AND MCD.ATTRIBUTE_3 = MLV_PRD.SR_LEVEL_PK
AND MCD.ATTRIBUTE_1 = MLV_PRD.INSTANCE