FND Design Data [Home] [Help]

View: WIPBV_REPETITIVE_SCHEDULES

Product: WIP - Work in Process
Description:
Implementation/DBA Data: ViewAPPS.WIPBV_REPETITIVE_SCHEDULES
View Text

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

Columns

Name
DAILY_PRODUCTION_RATE
PROCESSING_WORK_DAYS
"_LA:STATUS"
"_LA:FIRMED_PLANNED_FLAG"
FIRST_UNIT_START_DATE
FIRST_UNIT_COMPLETION_DATE
LAST_UNIT_START_DATE
LAST_UNIT_COMPLETION_DATE
CLOSED_DATE
COMPLETED_QUANTITY
BOM_REVISION_DATE
ROUTING_REVISION_DATE
ALTERNATE_BOM_DESIGNATOR
ALTERNATE_ROUTING_DESIGNATOR
DEMAND_CLASS
RELEASED_DATE
PO_CREATION_TIME
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
CREATED_DATE
CREATED_BY
UPDATED_DATE
UPDATED_BY