VIEW: APPS.MSC_LINE_ITEMS_LOV_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)