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