[Home] [Help] [Dependency Information]
Object Name: | BOM_COPY_STRUCTURE_REQUEST# |
---|---|
Object Type: | VIEW |
Owner: | BOM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COPY_REQUEST_ID | NUMBER | Yes | ||
SRC_ORG_ID | NUMBER | Yes | ||
SRC_ITEM_ID | NUMBER | Yes | ||
SRC_ITEM_REV_ID | NUMBER | Yes | ||
SRC_STRUCTURE_NAME | VARCHAR2 | (10) | ||
SRC_EXPLOSION_DATE | DATE | Yes | ||
SRC_FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
SRC_TO_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
SRC_FROM_END_ITEM_REV_ID | NUMBER | |||
SRC_FROM_END_ITEM_MNR_REV_ID | NUMBER | |||
SRC_TO_END_ITEM_REV_ID | NUMBER | |||
SRC_TO_END_ITEM_MNR_REV_ID | NUMBER | |||
SRC_FILTER | NUMBER | Yes | ||
SRC_ECO_FILTER | VARCHAR2 | (10) | ||
SRC_BILL_SEQUENCE_ID | NUMBER | Yes | ||
SRC_STRUCTURE_TYPE_ID | NUMBER | Yes | ||
SRC_EFFECTIVITY_CONTROL | NUMBER | Yes | ||
TRGT_ORG_ID | NUMBER | Yes | ||
TRGT_ITEM_ID | NUMBER | Yes | ||
TRGT_ITEM_REV_ID | NUMBER | Yes | ||
TRGT_STRUCTURE_NAME | VARCHAR2 | (10) | ||
TRGT_EFFECTIVITY_DATE | DATE | Yes | ||
TRGT_FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
TRGT_TO_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
TRGT_FROM_END_ITEM_REV_ID | NUMBER | |||
TRGT_FROM_END_ITEM_MNR_REV_ID | NUMBER | |||
TRGT_TO_END_ITEM_REV_ID | NUMBER | |||
TRGT_TO_END_ITEM_MNR_REV_ID | NUMBER | |||
TRGT_BILL_SEQUENCE_ID | NUMBER | |||
TRGT_STRUCTURE_TYPE_ID | NUMBER | Yes | ||
TRGT_EFFECTIVITY_CONTROL | NUMBER | Yes | ||
TRGT_STRUCTURE_DESCRIPTION | VARCHAR2 | (240) | ||
LEVELS_TO_COPY | NUMBER | Yes | ||
CPY_EXCLUSIONS | VARCHAR2 | (1) | Yes | |
CPY_ROUTINGS | VARCHAR2 | (1) | Yes | |
CPY_STRUCTURE_ATTRIBUTES | VARCHAR2 | (1) | Yes | |
CPY_COMPONENT_ATTRIBUTES | VARCHAR2 | (1) | Yes | |
CPY_STRUCTURE_ATTACHMENTS | VARCHAR2 | (1) | Yes | |
CPY_REFERENCE_DESIGNATORS | VARCHAR2 | (1) | Yes | |
CPY_SUBSTITUTE_COMPONENTS | VARCHAR2 | (1) | Yes | |
CPY_COMPONENT_OPERATIONS | VARCHAR2 | (1) | Yes | |
REQUEST_STATUS | VARCHAR2 | (1) | Yes | |
ORG_HIERARCHY_NAME | VARCHAR2 | (240) | ||
ORG_HIERARCHY_ID | NUMBER | |||
CHANGE_NOTICE | VARCHAR2 | (10) | ||
CHANGE_ID | NUMBER | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT COPY_REQUEST_ID
, SRC_ORG_ID
, SRC_ITEM_ID
, SRC_ITEM_REV_ID
, SRC_STRUCTURE_NAME
, SRC_EXPLOSION_DATE
, SRC_FROM_END_ITEM_UNIT_NUMBER
, SRC_TO_END_ITEM_UNIT_NUMBER
, SRC_FROM_END_ITEM_REV_ID
, SRC_FROM_END_ITEM_MNR_REV_ID
, SRC_TO_END_ITEM_REV_ID
, SRC_TO_END_ITEM_MNR_REV_ID
, SRC_FILTER
, SRC_ECO_FILTER
, SRC_BILL_SEQUENCE_ID
, SRC_STRUCTURE_TYPE_ID
, SRC_EFFECTIVITY_CONTROL
, TRGT_ORG_ID
, TRGT_ITEM_ID
, TRGT_ITEM_REV_ID
, TRGT_STRUCTURE_NAME
, TRGT_EFFECTIVITY_DATE
, TRGT_FROM_END_ITEM_UNIT_NUMBER
, TRGT_TO_END_ITEM_UNIT_NUMBER
, TRGT_FROM_END_ITEM_REV_ID
, TRGT_FROM_END_ITEM_MNR_REV_ID
, TRGT_TO_END_ITEM_REV_ID
, TRGT_TO_END_ITEM_MNR_REV_ID
, TRGT_BILL_SEQUENCE_ID
, TRGT_STRUCTURE_TYPE_ID
, TRGT_EFFECTIVITY_CONTROL
, TRGT_STRUCTURE_DESCRIPTION
, LEVELS_TO_COPY
, CPY_EXCLUSIONS
, CPY_ROUTINGS
, CPY_STRUCTURE_ATTRIBUTES
, CPY_COMPONENT_ATTRIBUTES
, CPY_STRUCTURE_ATTACHMENTS
, CPY_REFERENCE_DESIGNATORS
, CPY_SUBSTITUTE_COMPONENTS
, CPY_COMPONENT_OPERATIONS
, REQUEST_STATUS
, ORG_HIERARCHY_NAME
, ORG_HIERARCHY_ID
, CHANGE_NOTICE
, CHANGE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM BOM.BOM_COPY_STRUCTURE_REQUEST#;
|
|
|