Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | this view shows all the search criteria for exceptions |
Implementation/DBA Data: | APPS.MSC_SEARCH_ACTIONS_V |
SELECT P.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PLANS_TREE_V P
WHERE P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL UNION ALL SELECT P.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, NULL
, A.EXCEPTION_GROUP
, ML.MEANING
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PLANS_TREE_V P
, MSC_ACTIONS_TREE_V A
, MFG_LOOKUPS ML
WHERE P.PLAN_ID = A.PLAN_ID
AND P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL
AND ML.LOOKUP_CODE = A.EXCEPTION_GROUP
AND ML.LOOKUP_TYPE='MSC_EXCEPTION_GROUP' UNION ALL SELECT P.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, NULL
, A.EXCEPTION_GROUP
, ML_GRP.MEANING
, A.EXCEPTION_TYPE
, ML_TYPE.MEANING
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PLANS_TREE_V P
, MSC_ACTIONS_TREE_V A
, MFG_LOOKUPS ML_GRP
, MFG_LOOKUPS ML_TYPE
WHERE P.PLAN_ID = A.PLAN_ID
AND P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL
AND ML_GRP.LOOKUP_TYPE = 'MSC_EXCEPTION_GROUP'
AND ML_GRP.LOOKUP_CODE = A.EXCEPTION_GROUP
AND ML_TYPE.LOOKUP_TYPE = 'MRP_EXCEPTION_CODE_TYPE'
AND ML_TYPE.LOOKUP_CODE = A.EXCEPTION_TYPE UNION ALL SELECT P.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, NULL
, A.EXCEPTION_GROUP
, ML_GRP.MEANING
, A.EXCEPTION_TYPE
, ML_TYPE.MEANING
, O.SR_INSTANCE_ID
, O.ORGANIZATION_ID
, O.ORGANIZATION_CODE
, O.INVENTORY_ITEM_ID
, O.ITEM_NUMBER
, O.DEPARTMENT_ID
, O.DEPARTMENT_CODE
, O.RESOURCE_ID
, O.RESOURCE_CODE
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PLANS_TREE_V P
, MSC_ACTION_ORDERS_TREE_V O
, MSC_ACTIONS_TREE_V A
, MFG_LOOKUPS ML_GRP
, MFG_LOOKUPS ML_TYPE
WHERE P.PLAN_ID = A.PLAN_ID
AND P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL
AND A.PLAN_ID = O.PLAN_ID
AND A.EXCEPTION_TYPE = O.EXCEPTION_TYPE
AND ML_GRP.LOOKUP_TYPE = 'MSC_EXCEPTION_GROUP'
AND ML_GRP.LOOKUP_CODE = A.EXCEPTION_GROUP
AND ML_TYPE.LOOKUP_TYPE = 'MRP_EXCEPTION_CODE_TYPE'
AND ML_TYPE.LOOKUP_CODE = A.EXCEPTION_TYPE