[Home] [Help] [Dependency Information]
Object Name: | WIPBV_REPETITIVE_SCHEDULES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WIP.WIPBV_REPETITIVE_SCHEDULES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This shows information about repetitive schedules. Repetitive schedule information includes the schedule start and end dates, the production rate, the throughput, the assembly revision, the schedule status, and the WIP accounting class.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DAILY_PRODUCTION_RATE | NUMBER | Yes | ||
PROCESSING_WORK_DAYS | NUMBER | Yes | ||
_LA:STATUS | CHAR | (50) | ||
_LA:FIRMED_PLANNED_FLAG | CHAR | (52) | ||
FIRST_UNIT_START_DATE | DATE | Yes | ||
FIRST_UNIT_COMPLETION_DATE | DATE | Yes | ||
LAST_UNIT_START_DATE | DATE | Yes | ||
LAST_UNIT_COMPLETION_DATE | DATE | Yes | ||
CLOSED_DATE | DATE | |||
COMPLETED_QUANTITY | NUMBER | Yes | ||
BOM_REVISION_DATE | DATE | |||
ROUTING_REVISION_DATE | DATE | |||
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | ||
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | ||
DEMAND_CLASS | VARCHAR2 | (30) | ||
RELEASED_DATE | DATE | |||
PO_CREATION_TIME | CHAR | (61) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
REPETITIVE_SCHEDULE_ID | NUMBER | Yes | ||
WIP_ENTITY_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
LINE_ID | NUMBER | Yes | ||
COMMON_BOM_SEQUENCE_ID | NUMBER | |||
COMMON_ROUTING_SEQUENCE_ID | NUMBER | |||
MATERIAL_ACCOUNT | NUMBER | Yes | ||
MATERIAL_OVERHEAD_ACCOUNT | NUMBER | Yes | ||
RESOURCE_ACCOUNT | NUMBER | Yes | ||
OUTSIDE_PROCESSING_ACCOUNT | NUMBER | Yes | ||
MATERIAL_VARIANCE_ACCOUNT | NUMBER | Yes | ||
RESOURCE_VARIANCE_ACCOUNT | NUMBER | Yes | ||
OUTSIDE_PROC_VARIANCE_ACCOUNT | NUMBER | Yes | ||
OVERHEAD_ACCOUNT | NUMBER | Yes | ||
OVERHEAD_VARIANCE_ACCOUNT | NUMBER | Yes | ||
CREATED_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
UPDATED_DATE | DATE | Yes | ||
UPDATED_BY | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.WIPBV_REPETITIVE_SCHEDULES;
APPS.WIPBV_REPETITIVE_SCHEDULES is not referenced by any database object
|
|
|