Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: BOM.BOM_OP_RESOURCES_INTERFACE#

Object Details
Object Name: BOM_OP_RESOURCES_INTERFACE#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OPERATION_SEQUENCE_ID NUMBER

RESOURCE_SEQ_NUM NUMBER

RESOURCE_ID NUMBER

ACTIVITY_ID NUMBER

STANDARD_RATE_FLAG NUMBER

ASSIGNED_UNITS NUMBER

USAGE_RATE_OR_AMOUNT NUMBER

USAGE_RATE_OR_AMOUNT_INVERSE NUMBER

BASIS_TYPE NUMBER

SCHEDULE_FLAG NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

RESOURCE_OFFSET_PERCENT NUMBER

AUTOCHARGE_TYPE NUMBER

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)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ASSEMBLY_ITEM_ID NUMBER

ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
ORGANIZATION_ID NUMBER

OPERATION_SEQ_NUM NUMBER

EFFECTIVITY_DATE DATE

ROUTING_SEQUENCE_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (3)
ASSEMBLY_ITEM_NUMBER VARCHAR2 (240)
RESOURCE_CODE VARCHAR2 (10)
ACTIVITY VARCHAR2 (10)
TRANSACTION_ID NUMBER

PROCESS_FLAG NUMBER

TRANSACTION_TYPE VARCHAR2 (10)
NEW_RESOURCE_SEQ_NUM NUMBER

OPERATION_TYPE NUMBER

PRINCIPLE_FLAG NUMBER

SCHEDULE_SEQ_NUM NUMBER

ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
SETUP_CODE VARCHAR2 (30)
ECO_NAME VARCHAR2 (10)
NEW_ROUTING_REVISION VARCHAR2 (3)
ACD_TYPE NUMBER

ENG_CHANGES_IFCE_KEY VARCHAR2 (30)
ENG_REVISED_ITEMS_IFCE_KEY VARCHAR2 (30)
BOM_REV_OP_IFCE_KEY VARCHAR2 (30)
BOM_REV_OP_RES_IFCE_KEY VARCHAR2 (30)
NEW_REVISED_ITEM_REVISION VARCHAR2 (3)
SUBSTITUTE_GROUP_NUM NUMBER

BATCH_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OPERATION_SEQUENCE_ID
,      RESOURCE_SEQ_NUM
,      RESOURCE_ID
,      ACTIVITY_ID
,      STANDARD_RATE_FLAG
,      ASSIGNED_UNITS
,      USAGE_RATE_OR_AMOUNT
,      USAGE_RATE_OR_AMOUNT_INVERSE
,      BASIS_TYPE
,      SCHEDULE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RESOURCE_OFFSET_PERCENT
,      AUTOCHARGE_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ASSEMBLY_ITEM_ID
,      ALTERNATE_ROUTING_DESIGNATOR
,      ORGANIZATION_ID
,      OPERATION_SEQ_NUM
,      EFFECTIVITY_DATE
,      ROUTING_SEQUENCE_ID
,      ORGANIZATION_CODE
,      ASSEMBLY_ITEM_NUMBER
,      RESOURCE_CODE
,      ACTIVITY
,      TRANSACTION_ID
,      PROCESS_FLAG
,      TRANSACTION_TYPE
,      NEW_RESOURCE_SEQ_NUM
,      OPERATION_TYPE
,      PRINCIPLE_FLAG
,      SCHEDULE_SEQ_NUM
,      ORIGINAL_SYSTEM_REFERENCE
,      SETUP_CODE
,      ECO_NAME
,      NEW_ROUTING_REVISION
,      ACD_TYPE
,      ENG_CHANGES_IFCE_KEY
,      ENG_REVISED_ITEMS_IFCE_KEY
,      BOM_REV_OP_IFCE_KEY
,      BOM_REV_OP_RES_IFCE_KEY
,      NEW_REVISED_ITEM_REVISION
,      SUBSTITUTE_GROUP_NUM
,      BATCH_ID
FROM BOM.BOM_OP_RESOURCES_INTERFACE#;

Dependencies

[top of page]

BOM.BOM_OP_RESOURCES_INTERFACE# references the following:

SchemaBOM
TableBOM_OP_RESOURCES_INTERFACE
BOM.BOM_OP_RESOURCES_INTERFACE# is referenced by following:

SchemaAPPS
SynonymBOM_OP_RESOURCES_INTERFACE