| Name |
Datatype |
Length |
Prcn |
| REVISED_ITEM_NAME |
VARCHAR2
|
(700)
|
|
| REVISED_ITEM_ID |
NUMBER
|
|
|
| NEW_REVISED_ITEM_REVISION |
VARCHAR2
|
(3)
|
|
| NEW_REVISED_ITEM_REV_DESC |
VARCHAR2
|
(240)
|
|
| UPD_REVISED_ITEM_REVISION |
VARCHAR2
|
(3)
|
|
| START_EFFECTIVE_DATE |
DATE
|
|
|
| ITEM |
 INV_EBI_ITEM_OBJ
|
|
|
| STRUCTURE_HEADER |
INV_EBI_STRUCTURE_HEADER_OBJ
|
|
|
| COMPONENT_ITEM_TBL |
INV_EBI_REV_COMP_TBL
|
|
|
| REVISION_OPERATION_TBL |
INV_EBI_REV_OP_TBL
|
|
|
| REVISION_OP_RESOURCE_TBL |
INV_EBI_REV_OP_RES_TBL
|
|
|
| REVISION_SUB_RESOURCE_TBL |
INV_EBI_REV_SUB_RES_TBL
|
|
|
| NEW_EFFECTIVE_DATE |
DATE
|
|
|
| ALTERNATE_BOM_CODE |
VARCHAR2
|
(10)
|
|
| STATUS_TYPE |
NUMBER
|
|
|
| STATUS_CODE |
NUMBER
|
|
|
| STATUS_NAME |
VARCHAR2
|
(30)
|
|
| MRP_ACTIVE |
NUMBER
|
|
|
| EARLIEST_EFFECTIVE_DATE |
DATE
|
|
|
| USE_UP_ITEM_NAME |
VARCHAR2
|
(700)
|
|
| USE_UP_PLAN_NAME |
VARCHAR2
|
(10)
|
|
| REQUESTOR |
VARCHAR2
|
(30)
|
|
| DISPOSITION_TYPE |
NUMBER
|
|
|
| UP_WIP |
NUMBER
|
|
|
| CANCEL_COMMENTS |
VARCHAR2
|
(240)
|
|
| CHANGE_DESCRIPTION |
VARCHAR2
|
(240)
|
|
| ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
| ATTRIBUTE1 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE2 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE3 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE4 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE5 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE6 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE7 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE8 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE9 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE10 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE11 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE12 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE13 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE14 |
VARCHAR2
|
(150)
|
|
| ATTRIBUTE15 |
VARCHAR2
|
(150)
|
|
| FROM_END_ITEM_UNIT_NUMBER |
VARCHAR2
|
(30)
|
|
| NEW_FROM_END_ITEM_UNIT_NUMBER |
VARCHAR2
|
(30)
|
|
| ORIGINAL_SYSTEM_REFERENCE |
VARCHAR2
|
(50)
|
|
| RETURN_STATUS |
VARCHAR2
|
(1)
|
|
| TRANSACTION_TYPE |
VARCHAR2
|
(30)
|
|
| TRANSACTION_ID |
NUMBER
|
|
|
| FROM_WORK_ORDER |
VARCHAR2
|
(150)
|
|
| TO_WORK_ORDER |
VARCHAR2
|
(150)
|
|
| FROM_CUMULATIVE_QUANTITY |
NUMBER
|
|
|
| LOT_NUMBER |
VARCHAR2
|
(30)
|
|
| COMPLETION_SUBINVENTORY |
VARCHAR2
|
(10)
|
|
| COMPLETION_LOCATION_NAME |
VARCHAR2
|
(81)
|
|
| PRIORITY |
NUMBER
|
|
|
| CTP_FLAG |
NUMBER
|
|
|
| NEW_ROUTING_REVISION |
VARCHAR2
|
(3)
|
|
| UPD_ROUTING_REVISION |
VARCHAR2
|
(3)
|
|
| ROUTING_COMMENT |
VARCHAR2
|
(240)
|
|
| ECO_FOR_PRODUCTION |
NUMBER
|
|
|
| CHANGE_MANAGEMENT_TYPE |
VARCHAR2
|
(45)
|
|
| TRANSFER_OR_COPY |
VARCHAR2
|
(1)
|
|
| TRANSFER_OR_COPY_ITEM |
NUMBER
|
|
|
| TRANSFER_OR_COPY_BILL |
NUMBER
|
|
|
| TRANSFER_OR_COPY_ROUTING |
NUMBER
|
|
|
| COPY_TO_ITEM |
VARCHAR2
|
(2000)
|
|
| COPY_TO_ITEM_DESC |
VARCHAR2
|
(240)
|
|
| PARENT_REVISED_ITEM_NAME |
VARCHAR2
|
(240)
|
|
| PARENT_ALTERNATE_NAME |
VARCHAR2
|
(240)
|
|
| SELECTION_OPTION |
NUMBER
|
|
|
| SELECTION_DATE |
DATE
|
|
|
| SELECTION_UNIT_NUMBER |
VARCHAR2
|
(30)
|
|
| CURRENT_LIFECYCLE_PHASE_NAME |
VARCHAR2
|
(240)
|
|
| NEW_LIFECYCLE_PHASE_NAME |
VARCHAR2
|
(240)
|
|
| FROM_END_ITEM_REVISION |
VARCHAR2
|
(3)
|
|
| FROM_END_ITEM_STRC_REV |
VARCHAR2
|
(80)
|
|
| ENABLE_ITEM_IN_LOCAL_ORG |
VARCHAR2
|
(1)
|
|
| CREATE_BOM_IN_LOCAL_ORG |
VARCHAR2
|
(1)
|
|
| NEW_STRUCTURE_REVISION |
VARCHAR2
|
(80)
|
|
| PLAN_LEVEL |
NUMBER
|
|
|
| FROM_END_ITEM_NAME |
VARCHAR2
|
(700)
|
|
| FROM_END_ITEM_ALTERNATE |
VARCHAR2
|
(10)
|
|
| CURRENT_STRUCTURE_REV_NAME |
VARCHAR2
|
(80)
|
|
| RESCHEDULE_COMMENTS |
VARCHAR2
|
(240)
|
|
| FROM_ITEM_REVISION |
VARCHAR2
|
(3)
|
|
| NEW_REVISION_LABEL |
VARCHAR2
|
(80)
|
|
| NEW_REVISION_REASON |
VARCHAR2
|
(80)
|
|
| STRUCTURE_TYPE_NAME |
VARCHAR2
|
(80)
|
|
| ORIGNAL_BOM_REFERENCE |
INV_EBI_ORIG_BOM_REFERENCE
|
|
|
| ITEM_REVISION_UDA |
INV_EBI_UDA_INPUT_OBJ
|
|
|
| START_EFFECTIVE_DATE_STR |
VARCHAR2
|
(30)
|
|
| NEW_EFFECTIVE_DATE_STR |
VARCHAR2
|
(30)
|
|
| EARLIEST_EFFECTIVE_DATE_STR |
VARCHAR2
|
(30)
|
|
| SELECTION_DATE_STR |
VARCHAR2
|
(30)
|
|
[Home] [Help]
[Dependency Information]
APPS
STANDARD
- show dependent code
INV_EBI_CHANGE_ORDER_HELPER
- show dependent code