VIEW: APPS.MSC_MAINT_WORKORDERS_V

Source

View Text - Preformatted

SELECT mps.PLAN_ID, mps.INPUT_SCHEDULE_ID, mps.DESIGNATOR_TYPE, msc_get_name.lookup_meaning('MRP_DESIGNATOR_TYPE_SHORT',mps.DESIGNATOR_TYPE), md.SRC_DESIGNATOR, md.SRC_DESCRIPTION, mps.ORGANIZATION_ID, mps.SR_INSTANCE_ID, msc_get_name.instance_code(mps.sr_instance_id), mps.LAST_UPDATE_DATE, mps.LAST_UPDATED_BY, mps.CREATION_DATE, mps.CREATED_BY, mps.LAST_UPDATE_LOGIN, mps.ROWID FROM msc_plan_schedules mps, MSC_DESIGNATORS md WHERE md.DESIGNATOR_ID = mps.INPUT_SCHEDULE_ID and md.ORGANIZATION_ID = mps.ORGANIZATION_ID and md .SR_INSTANCE_ID = mps.SR_INSTANCE_ID and mps.DESIGNATOR_TYPE IN (12,13) UNION ALL SELECT mps.PLAN_ID, mps.INPUT_SCHEDULE_ID, mps.DESIGNATOR_TYPE, msc_get_name.lookup_meaning('MRP_DESIGNATOR_TYPE_SHORT',MPS.DESIGNATOR_TYPE), msc_get_name.lookup_meaning('MSC_MAINTENANCE_PLAN_TYPES',1),' ', mps.ORGANIZATION_ID, mps.SR_INSTANCE_ID,msc_get_name.instance_code(mps.sr_instance_id), mps.LAST_UPDATE_DATE, mps.LAST_UPDATED_BY, mps.CREATION_DATE, mps.CREATED_BY, mps.LAST_UPDATE_LOGIN ,mps.ROWID FROM msc_plan_schedules mps WHERE mps.input_schedule_id in ('-1001','-1002') AND mps.DESIGNATOR_TYPE IN (12,13)

View Text - HTML Formatted

SELECT MPS.PLAN_ID
, MPS.INPUT_SCHEDULE_ID
, MPS.DESIGNATOR_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT'
, MPS.DESIGNATOR_TYPE)
, MD.SRC_DESIGNATOR
, MD.SRC_DESCRIPTION
, MPS.ORGANIZATION_ID
, MPS.SR_INSTANCE_ID
, MSC_GET_NAME.INSTANCE_CODE(MPS.SR_INSTANCE_ID)
, MPS.LAST_UPDATE_DATE
, MPS.LAST_UPDATED_BY
, MPS.CREATION_DATE
, MPS.CREATED_BY
, MPS.LAST_UPDATE_LOGIN
, MPS.ROWID
FROM MSC_PLAN_SCHEDULES MPS
, MSC_DESIGNATORS MD
WHERE MD.DESIGNATOR_ID = MPS.INPUT_SCHEDULE_ID
AND MD.ORGANIZATION_ID = MPS.ORGANIZATION_ID
AND MD .SR_INSTANCE_ID = MPS.SR_INSTANCE_ID
AND MPS.DESIGNATOR_TYPE IN (12
, 13) UNION ALL SELECT MPS.PLAN_ID
, MPS.INPUT_SCHEDULE_ID
, MPS.DESIGNATOR_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_DESIGNATOR_TYPE_SHORT'
, MPS.DESIGNATOR_TYPE)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_MAINTENANCE_PLAN_TYPES'
, 1)
, ' '
, MPS.ORGANIZATION_ID
, MPS.SR_INSTANCE_ID
, MSC_GET_NAME.INSTANCE_CODE(MPS.SR_INSTANCE_ID)
, MPS.LAST_UPDATE_DATE
, MPS.LAST_UPDATED_BY
, MPS.CREATION_DATE
, MPS.CREATED_BY
, MPS.LAST_UPDATE_LOGIN
, MPS.ROWID
FROM MSC_PLAN_SCHEDULES MPS
WHERE MPS.INPUT_SCHEDULE_ID IN ('-1001'
, '-1002')
AND MPS.DESIGNATOR_TYPE IN (12
, 13)