VIEW: APPS.MRP_SRS_ORG_SELECT_SCHED_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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