VIEW: BOM.BOM_COPY_STRUCTURE_REQUEST#

Source

View Text - Preformatted

select COPY_REQUEST_ID COPY_REQUEST_ID, SRC_ORG_ID SRC_ORG_ID, SRC_ITEM_ID SRC_ITEM_ID, SRC_ITEM_REV_ID SRC_ITEM_REV_ID, SRC_STRUCTURE_NAME SRC_STRUCTURE_NAME, SRC_EXPLOSION_DATE SRC_EXPLOSION_DATE, SRC_FROM_END_ITEM_UNIT_NUMBER SRC_FROM_END_ITEM_UNIT_NUMBER, SRC_TO_END_ITEM_UNIT_NUMBER SRC_TO_END_ITEM_UNIT_NUMBER, SRC_FROM_END_ITEM_REV_ID SRC_FROM_END_ITEM_REV_ID, SRC_FROM_END_ITEM_MNR_REV_ID SRC_FROM_END_ITEM_MNR_REV_ID, SRC_TO_END_ITEM_REV_ID SRC_TO_END_ITEM_REV_ID, SRC_TO_END_ITEM_MNR_REV_ID SRC_TO_END_ITEM_MNR_REV_ID, SRC_FILTER SRC_FILTER, SRC_ECO_FILTER SRC_ECO_FILTER, SRC_BILL_SEQUENCE_ID SRC_BILL_SEQUENCE_ID, SRC_STRUCTURE_TYPE_ID SRC_STRUCTURE_TYPE_ID, SRC_EFFECTIVITY_CONTROL SRC_EFFECTIVITY_CONTROL, TRGT_ORG_ID TRGT_ORG_ID, TRGT_ITEM_ID TRGT_ITEM_ID, TRGT_ITEM_REV_ID TRGT_ITEM_REV_ID, TRGT_STRUCTURE_NAME TRGT_STRUCTURE_NAME, TRGT_EFFECTIVITY_DATE TRGT_EFFECTIVITY_DATE, TRGT_FROM_END_ITEM_UNIT_NUMBER TRGT_FROM_END_ITEM_UNIT_NUMBER, TRGT_TO_END_ITEM_UNIT_NUMBER TRGT_TO_END_ITEM_UNIT_NUMBER, TRGT_FROM_END_ITEM_REV_ID TRGT_FROM_END_ITEM_REV_ID, TRGT_FROM_END_ITEM_MNR_REV_ID TRGT_FROM_END_ITEM_MNR_REV_ID, TRGT_TO_END_ITEM_REV_ID TRGT_TO_END_ITEM_REV_ID, TRGT_TO_END_ITEM_MNR_REV_ID TRGT_TO_END_ITEM_MNR_REV_ID, TRGT_BILL_SEQUENCE_ID TRGT_BILL_SEQUENCE_ID, TRGT_STRUCTURE_TYPE_ID TRGT_STRUCTURE_TYPE_ID, TRGT_EFFECTIVITY_CONTROL TRGT_EFFECTIVITY_CONTROL, TRGT_STRUCTURE_DESCRIPTION TRGT_STRUCTURE_DESCRIPTION, LEVELS_TO_COPY LEVELS_TO_COPY, CPY_EXCLUSIONS CPY_EXCLUSIONS, CPY_ROUTINGS CPY_ROUTINGS, CPY_STRUCTURE_ATTRIBUTES CPY_STRUCTURE_ATTRIBUTES, CPY_COMPONENT_ATTRIBUTES CPY_COMPONENT_ATTRIBUTES, CPY_STRUCTURE_ATTACHMENTS CPY_STRUCTURE_ATTACHMENTS, CPY_REFERENCE_DESIGNATORS CPY_REFERENCE_DESIGNATORS, CPY_SUBSTITUTE_COMPONENTS CPY_SUBSTITUTE_COMPONENTS, CPY_COMPONENT_OPERATIONS CPY_COMPONENT_OPERATIONS, REQUEST_STATUS REQUEST_STATUS, ORG_HIERARCHY_NAME ORG_HIERARCHY_NAME, ORG_HIERARCHY_ID ORG_HIERARCHY_ID, CHANGE_NOTICE CHANGE_NOTICE, CHANGE_ID CHANGE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "BOM"."BOM_COPY_STRUCTURE_REQUEST"

View Text - HTML Formatted

SELECT COPY_REQUEST_ID COPY_REQUEST_ID
, SRC_ORG_ID SRC_ORG_ID
, SRC_ITEM_ID SRC_ITEM_ID
, SRC_ITEM_REV_ID SRC_ITEM_REV_ID
, SRC_STRUCTURE_NAME SRC_STRUCTURE_NAME
, SRC_EXPLOSION_DATE SRC_EXPLOSION_DATE
, SRC_FROM_END_ITEM_UNIT_NUMBER SRC_FROM_END_ITEM_UNIT_NUMBER
, SRC_TO_END_ITEM_UNIT_NUMBER SRC_TO_END_ITEM_UNIT_NUMBER
, SRC_FROM_END_ITEM_REV_ID SRC_FROM_END_ITEM_REV_ID
, SRC_FROM_END_ITEM_MNR_REV_ID SRC_FROM_END_ITEM_MNR_REV_ID
, SRC_TO_END_ITEM_REV_ID SRC_TO_END_ITEM_REV_ID
, SRC_TO_END_ITEM_MNR_REV_ID SRC_TO_END_ITEM_MNR_REV_ID
, SRC_FILTER SRC_FILTER
, SRC_ECO_FILTER SRC_ECO_FILTER
, SRC_BILL_SEQUENCE_ID SRC_BILL_SEQUENCE_ID
, SRC_STRUCTURE_TYPE_ID SRC_STRUCTURE_TYPE_ID
, SRC_EFFECTIVITY_CONTROL SRC_EFFECTIVITY_CONTROL
, TRGT_ORG_ID TRGT_ORG_ID
, TRGT_ITEM_ID TRGT_ITEM_ID
, TRGT_ITEM_REV_ID TRGT_ITEM_REV_ID
, TRGT_STRUCTURE_NAME TRGT_STRUCTURE_NAME
, TRGT_EFFECTIVITY_DATE TRGT_EFFECTIVITY_DATE
, TRGT_FROM_END_ITEM_UNIT_NUMBER TRGT_FROM_END_ITEM_UNIT_NUMBER
, TRGT_TO_END_ITEM_UNIT_NUMBER TRGT_TO_END_ITEM_UNIT_NUMBER
, TRGT_FROM_END_ITEM_REV_ID TRGT_FROM_END_ITEM_REV_ID
, TRGT_FROM_END_ITEM_MNR_REV_ID TRGT_FROM_END_ITEM_MNR_REV_ID
, TRGT_TO_END_ITEM_REV_ID TRGT_TO_END_ITEM_REV_ID
, TRGT_TO_END_ITEM_MNR_REV_ID TRGT_TO_END_ITEM_MNR_REV_ID
, TRGT_BILL_SEQUENCE_ID TRGT_BILL_SEQUENCE_ID
, TRGT_STRUCTURE_TYPE_ID TRGT_STRUCTURE_TYPE_ID
, TRGT_EFFECTIVITY_CONTROL TRGT_EFFECTIVITY_CONTROL
, TRGT_STRUCTURE_DESCRIPTION TRGT_STRUCTURE_DESCRIPTION
, LEVELS_TO_COPY LEVELS_TO_COPY
, CPY_EXCLUSIONS CPY_EXCLUSIONS
, CPY_ROUTINGS CPY_ROUTINGS
, CPY_STRUCTURE_ATTRIBUTES CPY_STRUCTURE_ATTRIBUTES
, CPY_COMPONENT_ATTRIBUTES CPY_COMPONENT_ATTRIBUTES
, CPY_STRUCTURE_ATTACHMENTS CPY_STRUCTURE_ATTACHMENTS
, CPY_REFERENCE_DESIGNATORS CPY_REFERENCE_DESIGNATORS
, CPY_SUBSTITUTE_COMPONENTS CPY_SUBSTITUTE_COMPONENTS
, CPY_COMPONENT_OPERATIONS CPY_COMPONENT_OPERATIONS
, REQUEST_STATUS REQUEST_STATUS
, ORG_HIERARCHY_NAME ORG_HIERARCHY_NAME
, ORG_HIERARCHY_ID ORG_HIERARCHY_ID
, CHANGE_NOTICE CHANGE_NOTICE
, CHANGE_ID CHANGE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "BOM"."BOM_COPY_STRUCTURE_REQUEST"