VIEW: APPS.MSC_ACTIONS_TREE_V

Source

View Text - Preformatted

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))))

View Text - HTML Formatted

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))))