Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_PLANS_TREE_V |
SELECT P.PLAN_ID
, P.COMPILE_DESIGNATOR
, D.DESCRIPTION
, P.ORGANIZATION_ID
, P.SR_INSTANCE_ID
, O.ORGANIZATION_ID
, O.SR_INSTANCE_ID
, NVL(D.ORGANIZATION_SELECTION
, 3)
, D.DISABLE_DATE
, P.PLAN_TYPE
, P.CURR_PLAN_TYPE
, ML.MEANING
, P.CURR_ASSIGNMENT_SET_ID
, P.CURR_FULL_PEGGING
, P.PLAN_CAPACITY_FLAG
, D.DEMAND_CLASS
, P.PLAN_COMPLETION_DATE
, P.DATA_COMPLETION_DATE
FROM MSC_DESIGNATORS D
, MSC_PLAN_ORGANIZATIONS O
, MSC_PLANS P
, MFG_LOOKUPS ML
WHERE P.ORGANIZATION_ID = D.ORGANIZATION_ID
AND P.SR_INSTANCE_ID = D.SR_INSTANCE_ID
AND P.COMPILE_DESIGNATOR = D.DESIGNATOR
AND P.PLAN_ID = O.PLAN_ID
AND P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL
AND P.PLAN_ID <> -1
AND ML.LOOKUP_TYPE = 'MRP_PLAN_TYPE'
AND ML.LOOKUP_CODE = P.CURR_PLAN_TYPE
AND NVL(P.COPY_PLAN_ID
, -1) < 0
AND NVL(D.COPY_DESIGNATOR_ID
, -1)<0 UNION SELECT P.PLAN_ID
, P.COMPILE_DESIGNATOR
, D.DESCRIPTION
, P.ORGANIZATION_ID
, P.SR_INSTANCE_ID
, P.ORGANIZATION_ID
, P.SR_INSTANCE_ID
, NVL(D.ORGANIZATION_SELECTION
, 3)
, D.DISABLE_DATE
, P.PLAN_TYPE
, P.CURR_PLAN_TYPE
, ML.MEANING
, P.CURR_ASSIGNMENT_SET_ID
, P.CURR_FULL_PEGGING
, P.PLAN_CAPACITY_FLAG
, D.DEMAND_CLASS
, P.PLAN_COMPLETION_DATE
, P.DATA_COMPLETION_DATE
FROM MSC_DESIGNATORS D
, MSC_PLANS P
, MFG_LOOKUPS ML
WHERE P.ORGANIZATION_ID = D.ORGANIZATION_ID
AND P.SR_INSTANCE_ID = D.SR_INSTANCE_ID
AND P.COMPILE_DESIGNATOR = D.DESIGNATOR
AND P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL
AND P.PLAN_ID <> -1
AND ML.LOOKUP_TYPE = 'MRP_PLAN_TYPE'
AND ML.LOOKUP_CODE = P.CURR_PLAN_TYPE
AND NVL(P.COPY_PLAN_ID
, -1) < 0
AND NVL(D.COPY_DESIGNATOR_ID
, -1)<0