[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ENGFV_ECO_REVISED_ITEMS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ENG.ENGFV_ECO_REVISED_ITEMS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This shows information about the revised items on an engineering
change order(ECO). Since each ECO may have more than one revised item
that refere to the same bill, the column REVISED_ITEM_SEQUENCE_ID is
used to differentiate between multiple occurences of the same item in
a ECO.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| _KF:REVISED_ITEM_NAME | CHAR | (16) | ||
| NEW_ITEM_REVISION | VARCHAR2 | (3) | New revision of the revised item | |
| START_EFFECTIVE_DATE | DATE | Yes | Date the revised item is scheduled to be implemented | |
| IMPLEMENTATION_DATE | DATE | Date the revised item is implemented | ||
| CHANGE_DESCRIPTION | VARCHAR2 | (240) | Description of the revised item change | |
| FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
| CANCELLATION_DATE | DATE | Date the revised item is cancelled | ||
| CANCELLATION_COMMENTS | VARCHAR2 | (240) | Comments about the cancellation | |
| EARLIEST_EFFECTIVE_DATE | DATE | Earliest date a revised item can be implemented | ||
| USE_UP_PLAN_NAME | VARCHAR2 | (10) | Name of the Use Up plan | |
| _LA:STATUS_TYPE | CHAR | (53) | Status of the revised item | |
| _LA:DISPOSITION_TYPE | CHAR | (68) | Disposition type | |
| _LA:MRP_ACTIVE | CHAR | (48) | Determines if revised item is available to MRP | |
| _LA:UPDATE_WIP | CHAR | (48) | Determines if WIP jobs and schedules are updated when the revised item is implemented | |
| _LA:USE_UP | CHAR | (44) | Flag indicating whether or not the use up date for an item is being used as the effective date for the revised item | |
| _KF:USE_UP_ITEM_NAME | CHAR | (16) | ||
| ECO_NAME | VARCHAR2 | (10) | Yes | Engineering change order |
| ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Organization name |
| BOM_ALTERNATE_CODE | VARCHAR2 | (10) | BOM alternate code for the bill | |
| _DF | CHAR | (28) | ||
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| REVISED_ITEM_ID | NUMBER | Yes | Revised item identifier | |
| REVISED_ITEM_SEQUENCE_ID | NUMBER | Yes | Revised item unique identifier | |
| BILL_SEQUENCE_ID | NUMBER | Bill of material identifier | ||
| USE_UP_ITEM_ID | NUMBER | Use up item identifier | ||
| CREATED_ON | DATE | Yes | Standard WHO column | |
| CREATED_BY | NUMBER | Yes | Standard WHO column | |
| UPDATED_ON | DATE | Yes | Standard WHO column | |
| UPDATED_BY | NUMBER | Yes | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT _KF:REVISED_ITEM_NAME
, NEW_ITEM_REVISION
, START_EFFECTIVE_DATE
, IMPLEMENTATION_DATE
, CHANGE_DESCRIPTION
, FROM_END_ITEM_UNIT_NUMBER
, CANCELLATION_DATE
, CANCELLATION_COMMENTS
, EARLIEST_EFFECTIVE_DATE
, USE_UP_PLAN_NAME
, _LA:STATUS_TYPE
, _LA:DISPOSITION_TYPE
, _LA:MRP_ACTIVE
, _LA:UPDATE_WIP
, _LA:USE_UP
, _KF:USE_UP_ITEM_NAME
, ECO_NAME
, ORGANIZATION_CODE
, ORGANIZATION_NAME
, BOM_ALTERNATE_CODE
, _DF
, ORGANIZATION_ID
, REVISED_ITEM_ID
, REVISED_ITEM_SEQUENCE_ID
, BILL_SEQUENCE_ID
, USE_UP_ITEM_ID
, CREATED_ON
, CREATED_BY
, UPDATED_ON
, UPDATED_BY
FROM APPS.ENGFV_ECO_REVISED_ITEMS;
APPS
BOM_STRUCTURES_B
ENG_REVISED_ITEMS
HR_ALL_ORGANIZATION_UNITS
MTL_PARAMETERS
MTL_SYSTEM_ITEMS_B
APPS.ENGFV_ECO_REVISED_ITEMS is not referenced by any database object
|
|
|
|