VIEW: APPS.WIPBV_REPETITIVE_SCHEDULES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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