View: MSC_LINE_ITEMS_LOV_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_LINE_ITEMS_LOV_V

View Text

SELECT MR.LINE_ID
, DEPT.DEPARTMENT_CODE
, MR.PLAN_ID
, MR.ORGANIZATION_ID
, MR.SR_INSTANCE_ID
, MR.ASSEMBLY_ITEM_ID
, MR.ALTERNATE_ROUTING_DESIGNATOR
, 1
FROM MSC_DEPARTMENT_RESOURCES DEPT
, MSC_ROUTINGS MR
WHERE MR.PLAN_ID = DEPT.PLAN_ID(+)
AND MR.SR_INSTANCE_ID = DEPT.SR_INSTANCE_ID(+)
AND MR.ORGANIZATION_ID = DEPT.ORGANIZATION_ID(+)
AND MR.LINE_ID = DEPT.DEPARTMENT_ID(+) UNION ALL SELECT MPE.LINE_ID
, DEPT.DEPARTMENT_CODE
, MPE.PLAN_ID
, MPE.ORGANIZATION_ID
, MPE.SR_INSTANCE_ID
, MPE.ITEM_ID
, NULL
, 2
FROM MSC_DEPARTMENT_RESOURCES DEPT
, MSC_PROCESS_EFFECTIVITY MPE
WHERE MPE.PLAN_ID = DEPT.PLAN_ID(+)
AND MPE.SR_INSTANCE_ID = DEPT.SR_INSTANCE_ID(+)
AND MPE.ORGANIZATION_ID = DEPT.ORGANIZATION_ID(+)
AND MPE.LINE_ID = DEPT.DEPARTMENT_ID(+)

Columns