View: MRP_SRS_ORG_SELECT_SCHED_V

Product:	MRP - Master Scheduling/MRP
Description:	Valid schedules in Report Parameters
Implementation/DBA Data:	APPS.MRP_SRS_ORG_SELECT_SCHED_V

View Text

SELECT L.LOOKUP_CODE CODE
, L.MEANING
, S.ORGANIZATION_ID S_ORG_ID
, S.SCHEDULE_DESIGNATOR DESIGNATOR
, P.ORGANIZATION_ID P_ORG_ID
, P.PLANNED_ORGANIZATION PLANNED_ORG
FROM MFG_LOOKUPS L
, MRP_PLAN_ORGANIZATIONS_V P
, MRP_SCHEDULE_DESIGNATORS S
WHERE L.LOOKUP_TYPE = 'MRP_REPORT_MULTIORG'
AND S.ORGANIZATION_ID = P.ORGANIZATION_ID(+)
AND S.SCHEDULE_DESIGNATOR = P.COMPILE_DESIGNATOR(+)
AND ((L.LOOKUP_CODE = 2
AND NVL(P.ORGANIZATION_SELECTION
, 1) <> 1) OR (L.LOOKUP_CODE = 1
AND ((NVL(P.PLANNED_ORGANIZATION
, 0) <> NVL(P.ORGANIZATION_ID
, 1)
AND NVL(P.ORGANIZATION_SELECTION
, 1) <> 1) OR (NVL(P.PLANNED_ORGANIZATION
, 1) = NVL(P.ORGANIZATION_ID
, 1)
AND NVL(P.ORGANIZATION_SELECTION
, 1) = 1))))

Columns