View: GMP_PLAN_ORGANIZATION_V

Product:	GMP - Process Manufacturing Process Planning
Description:	List of all Organizations from plan along with additional entry for All as organization. When All is selected, Planning Detail Report will consider all the organizations defined in the plan.
Implementation/DBA Data:	APPS.GMP_PLAN_ORGANIZATION_V

View Text

SELECT ORGANIZATION_ID
, ORGANIZATION_CODE
, SR_INSTANCE_ID
, PLAN_ID
FROM MSC_PLAN_ORGANIZATIONS UNION ALL SELECT LOOKUP_CODE ORGANIZATION_ID
, MEANING ORGANIZATION_CODE
, TO_NUMBER(NULL) SR_INSTANCE_ID
, TO_NUMBER(NULL) PLAN_ID
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE='MSC_ALL_ORGANIZATIONS'

Columns