Product: | WIP - Work in Process |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WIPBV_REPETITIVE_SCHEDULES |
SELECT DAILY_PRODUCTION_RATE
, PROCESSING_WORK_DAYS
, '_LA:STATUS_TYPE:MFG_LOOKUPS:WIP_JOB_STATUS:MEANING'
, '_LA:FIRM_PLANNED_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, FIRST_UNIT_START_DATE
, FIRST_UNIT_COMPLETION_DATE
, LAST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE
, DATE_CLOSED
, QUANTITY_COMPLETED
, BOM_REVISION_DATE
, ROUTING_REVISION_DATE
, ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR
, DEMAND_CLASS
, DATE_RELEASED
, '_LA:PO_CREATION_TIME:MFG_LOOKUPS:WIP_PO_CREATION_TIME:MEANING'
, DESCRIPTION
, REPETITIVE_SCHEDULE_ID
, WIP_ENTITY_ID
, ORGANIZATION_ID
, LINE_ID
, COMMON_BOM_SEQUENCE_ID
, COMMON_ROUTING_SEQUENCE_ID
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, MATERIAL_VARIANCE_ACCOUNT
, RESOURCE_VARIANCE_ACCOUNT
, OUTSIDE_PROC_VARIANCE_ACCOUNT
, OVERHEAD_ACCOUNT
, OVERHEAD_VARIANCE_ACCOUNT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM WIP_REPETITIVE_SCHEDULES
WHERE '_SEC:WIP_REPETITIVE_SCHEDULES.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY