View: MSC_ACTIONS_TREE_V

Product:	MSC - Advanced Supply Chain Planning
Description:	This view shows all the exceptions in the tree
Implementation/DBA Data:	APPS.MSC_ACTIONS_TREE_V

View Text

SELECT MIE.PLAN_ID
, MIE.VERSION
, MIE.EXCEPTION_GROUP
, MIE.EXCEPTION_TYPE
, MIE.ORGANIZATION_ID
, MIE.SR_INSTANCE_ID
FROM MSC_ITEM_EXCEPTIONS MIE UNION ALL SELECT S.PLAN_ID
, TO_NUMBER(NULL)
, 10
, DECODE(S.ORDER_TYPE
, 13
, 104
, 5
, DECODE(I.BUILD_IN_WIP_FLAG
, 1
, DECODE(S.SOURCE_ORGANIZATION_ID
, S.ORGANIZATION_ID
, DECODE( S.SOURCE_SR_INSTANCE_ID
, S.SR_INSTANCE_ID
, DECODE( MSC_GET_NAME.CFM_ROUTING_FLAG(S.PLAN_ID
, S.ORGANIZATION_ID
, S.SR_INSTANCE_ID
, S.INVENTORY_ITEM_ID
, S.ALTERNATE_ROUTING_DESIGNATOR)
, 1
, 103
, 102)
, DECODE( S.SOURCE_ORGANIZATION_ID
, NULL
, DECODE(I.PLANNING_MAKE_BUY_CODE
, 2
, 101
, DECODE(MSC_GET_NAME.CFM_ROUTING_FLAG(S.PLAN_ID
, S.ORGANIZATION_ID
, S.SR_INSTANCE_ID
, S.INVENTORY_ITEM_ID
, S.ALTERNATE_ROUTING_DESIGNATOR)
, 1
, 103
, 102))
, 101)
, 101)
, 101)
, 101))
, S.ORGANIZATION_ID
, S.SR_INSTANCE_ID
FROM MSC_WORKBENCH_DISPLAY_OPTIONS W
, MSC_SYSTEM_ITEMS I
, MSC_SUPPLIES S
, MSC_PLANS P
WHERE W.USER_ID = FND_GLOBAL.USER_ID
AND P.PLAN_ID = S.PLAN_ID AND S.NEW_ORDER_PLACEMENT_DATE <= (P.PLAN_START_DATE + NVL(W.RECOMMENDATION_DAYS
, 0)) AND S.PLAN_ID = I.PLAN_ID AND S.ORGANIZATION_ID = I.ORGANIZATION_ID AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND ((S.ORDER_TYPE = 13) OR (S.ORDER_TYPE = 5
AND (((S.SOURCE_ORGANIZATION_ID <> S.ORGANIZATION_ID OR S.SOURCE_SR_INSTANCE_ID <> S.SR_INSTANCE_ID OR S.SOURCE_SUPPLIER_ID IS NOT NULL)
AND I.PURCHASING_ENABLED_FLAG = 1) OR (S.SOURCE_ORGANIZATION_ID IS NULL
AND S.SOURCE_SUPPLIER_ID IS NULL
AND I.PLANNING_MAKE_BUY_CODE = 2
AND I.PURCHASING_ENABLED_FLAG = 1) OR (S.SOURCE_ORGANIZATION_ID = S.ORGANIZATION_ID
AND S.SOURCE_SR_INSTANCE_ID = S.SR_INSTANCE_ID
AND I.BUILD_IN_WIP_FLAG = 1) OR (S.SOURCE_ORGANIZATION_ID IS NULL
AND S.SOURCE_SUPPLIER_ID IS NULL
AND I.PLANNING_MAKE_BUY_CODE = 1
AND I.BUILD_IN_WIP_FLAG = 1))))

Columns