VIEW: BOM.BOM_DELETE_SUB_ENTITIES#

Source

View Text - Preformatted

select DELETE_ENTITY_SEQUENCE_ID DELETE_ENTITY_SEQUENCE_ID, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, EFFECTIVITY_DATE EFFECTIVITY_DATE, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER, COMPONENT_ITEM_ID COMPONENT_ITEM_ID, COMPONENT_CONCAT_SEGMENTS COMPONENT_CONCAT_SEGMENTS, ITEM_NUM ITEM_NUM, DISABLE_DATE DISABLE_DATE, TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER, DESCRIPTION DESCRIPTION, OPERATION_DEPARTMENT_CODE OPERATION_DEPARTMENT_CODE, DELETE_STATUS_TYPE DELETE_STATUS_TYPE, DELETE_DATE DELETE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, 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_DELETE_SUB_ENTITIES"

View Text - HTML Formatted

SELECT DELETE_ENTITY_SEQUENCE_ID DELETE_ENTITY_SEQUENCE_ID
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, COMPONENT_ITEM_ID COMPONENT_ITEM_ID
, COMPONENT_CONCAT_SEGMENTS COMPONENT_CONCAT_SEGMENTS
, ITEM_NUM ITEM_NUM
, DISABLE_DATE DISABLE_DATE
, TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER
, DESCRIPTION DESCRIPTION
, OPERATION_DEPARTMENT_CODE OPERATION_DEPARTMENT_CODE
, DELETE_STATUS_TYPE DELETE_STATUS_TYPE
, DELETE_DATE DELETE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, 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_DELETE_SUB_ENTITIES"