VIEW: APPS.WIP_REPETITIVE_SCHEDULES_V

Source

View Text - Preformatted

SELECT WRS.ROWID ROW_ID , WRS.REPETITIVE_SCHEDULE_ID , WRS.ORGANIZATION_ID , WRS.LAST_UPDATE_DATE , WRS.LAST_UPDATED_BY , WRS.CREATION_DATE , WRS.CREATED_BY , WRS.LAST_UPDATE_LOGIN , WRS.REQUEST_ID , WRS.PROGRAM_APPLICATION_ID , WRS.PROGRAM_ID , WRS.PROGRAM_UPDATE_DATE , WRS.WIP_ENTITY_ID , WRS.LINE_ID , WL.LINE_CODE , WL.DESCRIPTION LINE_DESCRIPTION , WRI.PRODUCTION_LINE_RATE , WRI.CLASS_CODE , WRI.PRIMARY_ITEM_ID , WL.LINE_SCHEDULE_TYPE , WRS.DAILY_PRODUCTION_RATE , WRS.PROCESSING_WORK_DAYS ,ROUND (WRS.PROCESSING_WORK_DAYS * WRS.DAILY_PRODUCTION_RATE, 6) TOTAL_QUANTITY , WRS.STATUS_TYPE , LU.MEANING STATUS , WRS.FIRM_PLANNED_FLAG , WRS.ALTERNATE_BOM_DESIGNATOR , WRS.COMMON_BOM_SEQUENCE_ID , WRS.BOM_REVISION , WRS.BOM_REVISION_DATE , WRS.ALTERNATE_ROUTING_DESIGNATOR , WRS.COMMON_ROUTING_SEQUENCE_ID , WRS.ROUTING_REVISION , WRS.ROUTING_REVISION_DATE , WRS.FIRST_UNIT_START_DATE , WRS.FIRST_UNIT_COMPLETION_DATE , WRS.LAST_UNIT_START_DATE , WRS.LAST_UNIT_COMPLETION_DATE , WRS.DATE_RELEASED , WRS.DATE_CLOSED , DECODE(WRS.QUANTITY_COMPLETED, 0, NULL, WRS.QUANTITY_COMPLETED) QUANTITY_COMPLETED , WRS.DESCRIPTION , WRS.DEMAND_CLASS , WRS.MATERIAL_ACCOUNT , WRS.MATERIAL_OVERHEAD_ACCOUNT , WRS.RESOURCE_ACCOUNT , WRS.OVERHEAD_ACCOUNT , WRS.OUTSIDE_PROCESSING_ACCOUNT , WRS.MATERIAL_VARIANCE_ACCOUNT , WRS.OVERHEAD_VARIANCE_ACCOUNT , WRS.RESOURCE_VARIANCE_ACCOUNT , WRS.OUTSIDE_PROC_VARIANCE_ACCOUNT , WRS.ATTRIBUTE_CATEGORY , WRS.ATTRIBUTE1 , WRS.ATTRIBUTE2 , WRS.ATTRIBUTE3 , WRS.ATTRIBUTE4 , WRS.ATTRIBUTE5 , WRS.ATTRIBUTE6 , WRS.ATTRIBUTE7 , WRS.ATTRIBUTE8 , WRS.ATTRIBUTE9 , WRS.ATTRIBUTE10 , WRS.ATTRIBUTE11 , WRS.ATTRIBUTE12 , WRS.ATTRIBUTE13 , WRS.ATTRIBUTE14 , WRS.ATTRIBUTE15 , WRI.WIP_SUPPLY_TYPE , DECODE(SUM(WO.QUANTITY_SCRAPPED), 0, NULL,SUM( WO.QUANTITY_SCRAPPED)) QUANTITY_SCRAPPED ,ROUND((WL.MAXIMUM_RATE*DECODE(SIGN(WL.STOP_TIME - WL.START_TIME), -1, 86400 + WL.STOP_TIME - WL.START_TIME, 0, 86400, WL.STOP_TIME - WL.START_TIME) / 3600), 6) LINE_DAILY_MAXIMUM , WRS.PO_CREATION_TIME FROM MFG_LOOKUPS LU , WIP_OPERATIONS WO , WIP_LINES WL , WIP_REPETITIVE_ITEMS WRI , WIP_REPETITIVE_SCHEDULES WRS WHERE WRI.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID AND WRI.ORGANIZATION_ID = WRS.ORGANIZATION_ID AND WRI.LINE_ID = WRS.LINE_ID AND WL.ORGANIZATION_ID = WRS.ORGANIZATION_ID AND WL.LINE_ID = WRS.LINE_ID AND LU.LOOKUP_CODE = WRS.STATUS_TYPE AND LU.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND WO.REPETITIVE_SCHEDULE_ID (+) = WRS.REPETITIVE_SCHEDULE_ID AND WO.ORGANIZATION_ID (+) = WRS.ORGANIZATION_ID GROUP BY WRS.ROWID , WRS.REPETITIVE_SCHEDULE_ID , WRS.ORGANIZATION_ID , WRS.LAST_UPDATE_DATE , WRS.LAST_UPDATED_BY , WRS.CREATION_DATE , WRS.CREATED_BY , WRS.LAST_UPDATE_LOGIN , WRS.REQUEST_ID , WRS.PROGRAM_APPLICATION_ID , WRS.PROGRAM_ID , WRS.PROGRAM_UPDATE_DATE , WRS.WIP_ENTITY_ID , WRS.LINE_ID , WL.LINE_CODE , WL.DESCRIPTION , WRI.PRODUCTION_LINE_RATE , WRI.CLASS_CODE , WRI.PRIMARY_ITEM_ID , WL.LINE_SCHEDULE_TYPE , WRS.DAILY_PRODUCTION_RATE , WRS.PROCESSING_WORK_DAYS ,ROUND (WRS.PROCESSING_WORK_DAYS * WRS.DAILY_PRODUCTION_RATE, 6) , WRS.STATUS_TYPE , LU.MEANING , WRS.FIRM_PLANNED_FLAG , WRS.ALTERNATE_BOM_DESIGNATOR , WRS.COMMON_BOM_SEQUENCE_ID , WRS.BOM_REVISION , WRS.BOM_REVISION_DATE , WRS.ALTERNATE_ROUTING_DESIGNATOR , WRS.COMMON_ROUTING_SEQUENCE_ID , WRS.ROUTING_REVISION , WRS.ROUTING_REVISION_DATE , WRS.FIRST_UNIT_START_DATE , WRS.FIRST_UNIT_COMPLETION_DATE , WRS.LAST_UNIT_START_DATE , WRS.LAST_UNIT_COMPLETION_DATE , WRS.DATE_RELEASED , WRS.DATE_CLOSED , DECODE(WRS.QUANTITY_COMPLETED, 0, NULL, WRS.QUANTITY_COMPLETED) , WRS.DESCRIPTION , WRS.DEMAND_CLASS , WRS.MATERIAL_ACCOUNT , WRS.MATERIAL_OVERHEAD_ACCOUNT , WRS.RESOURCE_ACCOUNT , WRS.OVERHEAD_ACCOUNT , WRS.OUTSIDE_PROCESSING_ACCOUNT , WRS.MATERIAL_VARIANCE_ACCOUNT , WRS.OVERHEAD_VARIANCE_ACCOUNT , WRS.RESOURCE_VARIANCE_ACCOUNT , WRS.OUTSIDE_PROC_VARIANCE_ACCOUNT , WRS.ATTRIBUTE_CATEGORY , WRS.ATTRIBUTE1 , WRS.ATTRIBUTE2 , WRS.ATTRIBUTE3 , WRS.ATTRIBUTE4 , WRS.ATTRIBUTE5 , WRS.ATTRIBUTE6 , WRS.ATTRIBUTE7 , WRS.ATTRIBUTE8 , WRS.ATTRIBUTE9 , WRS.ATTRIBUTE10 , WRS.ATTRIBUTE11 , WRS.ATTRIBUTE12 , WRS.ATTRIBUTE13 , WRS.ATTRIBUTE14 , WRS.ATTRIBUTE15 , WRI.WIP_SUPPLY_TYPE ,ROUND((WL.MAXIMUM_RATE*DECODE(SIGN(WL.STOP_TIME -WL.START_TIME), -1, 86400 + WL.STOP_TIME - WL.START_TIME, 0, 86400,WL.STOP_TIME -WL.START_TIME) / 3600), 6) , WRS.PO_CREATION_TIME

View Text - HTML Formatted

SELECT WRS.ROWID ROW_ID
, WRS.REPETITIVE_SCHEDULE_ID
, WRS.ORGANIZATION_ID
, WRS.LAST_UPDATE_DATE
, WRS.LAST_UPDATED_BY
, WRS.CREATION_DATE
, WRS.CREATED_BY
, WRS.LAST_UPDATE_LOGIN
, WRS.REQUEST_ID
, WRS.PROGRAM_APPLICATION_ID
, WRS.PROGRAM_ID
, WRS.PROGRAM_UPDATE_DATE
, WRS.WIP_ENTITY_ID
, WRS.LINE_ID
, WL.LINE_CODE
, WL.DESCRIPTION LINE_DESCRIPTION
, WRI.PRODUCTION_LINE_RATE
, WRI.CLASS_CODE
, WRI.PRIMARY_ITEM_ID
, WL.LINE_SCHEDULE_TYPE
, WRS.DAILY_PRODUCTION_RATE
, WRS.PROCESSING_WORK_DAYS
, ROUND (WRS.PROCESSING_WORK_DAYS * WRS.DAILY_PRODUCTION_RATE
, 6) TOTAL_QUANTITY
, WRS.STATUS_TYPE
, LU.MEANING STATUS
, WRS.FIRM_PLANNED_FLAG
, WRS.ALTERNATE_BOM_DESIGNATOR
, WRS.COMMON_BOM_SEQUENCE_ID
, WRS.BOM_REVISION
, WRS.BOM_REVISION_DATE
, WRS.ALTERNATE_ROUTING_DESIGNATOR
, WRS.COMMON_ROUTING_SEQUENCE_ID
, WRS.ROUTING_REVISION
, WRS.ROUTING_REVISION_DATE
, WRS.FIRST_UNIT_START_DATE
, WRS.FIRST_UNIT_COMPLETION_DATE
, WRS.LAST_UNIT_START_DATE
, WRS.LAST_UNIT_COMPLETION_DATE
, WRS.DATE_RELEASED
, WRS.DATE_CLOSED
, DECODE(WRS.QUANTITY_COMPLETED
, 0
, NULL
, WRS.QUANTITY_COMPLETED) QUANTITY_COMPLETED
, WRS.DESCRIPTION
, WRS.DEMAND_CLASS
, WRS.MATERIAL_ACCOUNT
, WRS.MATERIAL_OVERHEAD_ACCOUNT
, WRS.RESOURCE_ACCOUNT
, WRS.OVERHEAD_ACCOUNT
, WRS.OUTSIDE_PROCESSING_ACCOUNT
, WRS.MATERIAL_VARIANCE_ACCOUNT
, WRS.OVERHEAD_VARIANCE_ACCOUNT
, WRS.RESOURCE_VARIANCE_ACCOUNT
, WRS.OUTSIDE_PROC_VARIANCE_ACCOUNT
, WRS.ATTRIBUTE_CATEGORY
, WRS.ATTRIBUTE1
, WRS.ATTRIBUTE2
, WRS.ATTRIBUTE3
, WRS.ATTRIBUTE4
, WRS.ATTRIBUTE5
, WRS.ATTRIBUTE6
, WRS.ATTRIBUTE7
, WRS.ATTRIBUTE8
, WRS.ATTRIBUTE9
, WRS.ATTRIBUTE10
, WRS.ATTRIBUTE11
, WRS.ATTRIBUTE12
, WRS.ATTRIBUTE13
, WRS.ATTRIBUTE14
, WRS.ATTRIBUTE15
, WRI.WIP_SUPPLY_TYPE
, DECODE(SUM(WO.QUANTITY_SCRAPPED)
, 0
, NULL
, SUM( WO.QUANTITY_SCRAPPED)) QUANTITY_SCRAPPED
, ROUND((WL.MAXIMUM_RATE*DECODE(SIGN(WL.STOP_TIME - WL.START_TIME)
, -1
, 86400 + WL.STOP_TIME - WL.START_TIME
, 0
, 86400
, WL.STOP_TIME - WL.START_TIME) / 3600)
, 6) LINE_DAILY_MAXIMUM
, WRS.PO_CREATION_TIME
FROM MFG_LOOKUPS LU
, WIP_OPERATIONS WO
, WIP_LINES WL
, WIP_REPETITIVE_ITEMS WRI
, WIP_REPETITIVE_SCHEDULES WRS
WHERE WRI.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
AND WRI.ORGANIZATION_ID = WRS.ORGANIZATION_ID
AND WRI.LINE_ID = WRS.LINE_ID
AND WL.ORGANIZATION_ID = WRS.ORGANIZATION_ID
AND WL.LINE_ID = WRS.LINE_ID
AND LU.LOOKUP_CODE = WRS.STATUS_TYPE
AND LU.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND WO.REPETITIVE_SCHEDULE_ID (+) = WRS.REPETITIVE_SCHEDULE_ID
AND WO.ORGANIZATION_ID (+) = WRS.ORGANIZATION_ID GROUP BY WRS.ROWID
, WRS.REPETITIVE_SCHEDULE_ID
, WRS.ORGANIZATION_ID
, WRS.LAST_UPDATE_DATE
, WRS.LAST_UPDATED_BY
, WRS.CREATION_DATE
, WRS.CREATED_BY
, WRS.LAST_UPDATE_LOGIN
, WRS.REQUEST_ID
, WRS.PROGRAM_APPLICATION_ID
, WRS.PROGRAM_ID
, WRS.PROGRAM_UPDATE_DATE
, WRS.WIP_ENTITY_ID
, WRS.LINE_ID
, WL.LINE_CODE
, WL.DESCRIPTION
, WRI.PRODUCTION_LINE_RATE
, WRI.CLASS_CODE
, WRI.PRIMARY_ITEM_ID
, WL.LINE_SCHEDULE_TYPE
, WRS.DAILY_PRODUCTION_RATE
, WRS.PROCESSING_WORK_DAYS
, ROUND (WRS.PROCESSING_WORK_DAYS * WRS.DAILY_PRODUCTION_RATE
, 6)
, WRS.STATUS_TYPE
, LU.MEANING
, WRS.FIRM_PLANNED_FLAG
, WRS.ALTERNATE_BOM_DESIGNATOR
, WRS.COMMON_BOM_SEQUENCE_ID
, WRS.BOM_REVISION
, WRS.BOM_REVISION_DATE
, WRS.ALTERNATE_ROUTING_DESIGNATOR
, WRS.COMMON_ROUTING_SEQUENCE_ID
, WRS.ROUTING_REVISION
, WRS.ROUTING_REVISION_DATE
, WRS.FIRST_UNIT_START_DATE
, WRS.FIRST_UNIT_COMPLETION_DATE
, WRS.LAST_UNIT_START_DATE
, WRS.LAST_UNIT_COMPLETION_DATE
, WRS.DATE_RELEASED
, WRS.DATE_CLOSED
, DECODE(WRS.QUANTITY_COMPLETED
, 0
, NULL
, WRS.QUANTITY_COMPLETED)
, WRS.DESCRIPTION
, WRS.DEMAND_CLASS
, WRS.MATERIAL_ACCOUNT
, WRS.MATERIAL_OVERHEAD_ACCOUNT
, WRS.RESOURCE_ACCOUNT
, WRS.OVERHEAD_ACCOUNT
, WRS.OUTSIDE_PROCESSING_ACCOUNT
, WRS.MATERIAL_VARIANCE_ACCOUNT
, WRS.OVERHEAD_VARIANCE_ACCOUNT
, WRS.RESOURCE_VARIANCE_ACCOUNT
, WRS.OUTSIDE_PROC_VARIANCE_ACCOUNT
, WRS.ATTRIBUTE_CATEGORY
, WRS.ATTRIBUTE1
, WRS.ATTRIBUTE2
, WRS.ATTRIBUTE3
, WRS.ATTRIBUTE4
, WRS.ATTRIBUTE5
, WRS.ATTRIBUTE6
, WRS.ATTRIBUTE7
, WRS.ATTRIBUTE8
, WRS.ATTRIBUTE9
, WRS.ATTRIBUTE10
, WRS.ATTRIBUTE11
, WRS.ATTRIBUTE12
, WRS.ATTRIBUTE13
, WRS.ATTRIBUTE14
, WRS.ATTRIBUTE15
, WRI.WIP_SUPPLY_TYPE
, ROUND((WL.MAXIMUM_RATE*DECODE(SIGN(WL.STOP_TIME -WL.START_TIME)
, -1
, 86400 + WL.STOP_TIME - WL.START_TIME
, 0
, 86400
, WL.STOP_TIME -WL.START_TIME) / 3600)
, 6)
, WRS.PO_CREATION_TIME