View: MRP_SRS_ORG_SELECT_PLAN_V

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

View Text

SELECT L.LOOKUP_CODE CODE
, L.MEANING
, P.ORGANIZATION_ID ORG_ID
, P.COMPILE_DESIGNATOR DESIGNATOR
, P.PLANNED_ORGANIZATION PLANNED_ORG
FROM MFG_LOOKUPS L
, MRP_PLAN_ORGANIZATIONS_V P
WHERE L.LOOKUP_TYPE = 'MRP_REPORT_MULTIORG'
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