View: MSC_RESOURCES_TREE_V

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

View Text

SELECT PLAN_ID
, SR_INSTANCE_ID
, ORGANIZATION_ID
, DEPARTMENT_CLASS
, RESOURCE_GROUP_CODE
, RESOURCE_GROUP_NAME
, DEPARTMENT_ID
, DEPARTMENT_CODE
, DEPARTMENT_DESCRIPTION
, RESOURCE_ID
, RESOURCE_CODE
, RESOURCE_DESCRIPTION
, LINE_FLAG
, BATCHABLE_FLAG
FROM MSC_DEPARTMENT_RESOURCES UNION ALL SELECT PLAN_ID
, SR_INSTANCE_ID2
, TO_ORGANIZATION_ID
, NULL
, NULL
, NULL
, FROM_ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(FROM_ORGANIZATION_ID
, SR_INSTANCE_ID)
, NULL
, TRANSACTION_ID
, SHIP_METHOD
, NULL
, 3
, TO_NUMBER(NULL)
FROM MSC_INTERORG_SHIP_METHODS UNION ALL SELECT DISTINCT S.PLAN_ID
, S.SR_INSTANCE_ID
, S.ORGANIZATION_ID
, NULL
, NULL
, NULL
, S.LINE_ID
, D.DEPARTMENT_CODE
, D.DEPARTMENT_DESCRIPTION
, -1
, NULL
, NULL
, 1
, TO_NUMBER(NULL)
FROM MSC_SUPPLIES S
, MSC_DEPARTMENT_RESOURCES D
WHERE S.LINE_ID = D.DEPARTMENT_ID
AND S.ORGANIZATION_ID = D.ORGANIZATION_ID
AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
AND D.PLAN_ID = -1
AND D.RESOURCE_ID = -1
AND S.LINE_ID IS NOT NULL

Columns