View: WIP_REPETITIVE_SCHEDULES_V

Product:	WIP - Work in Process
Description:	Foreign-key data for WIP_REPETITIVE_SCHEDULES
Implementation/DBA Data:	APPS.WIP_REPETITIVE_SCHEDULES_V

View Text

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

Columns