VIEW: APPS.MSC_RESOURCES_TREE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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