Skip to content

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

VIEW: MSC.MSC_ST_JOB_REQUIREMENT_OPS#

Object Details
Object Name: MSC_ST_JOB_REQUIREMENT_OPS#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER

SR_INSTANCE_ID NUMBER

OPERATION_SEQ_NUM NUMBER

COMPONENT_ITEM_ID NUMBER

PRIMARY_COMPONENT_ID NUMBER

SOURCE_PHANTOM_ID NUMBER

RECO_DATE_REQUIRED DATE

ORGANIZATION_ID NUMBER

COMPONENT_SEQUENCE_ID NUMBER

COMPONENT_PRIORITY NUMBER

DEPARTMENT_ID NUMBER

QUANTITY_PER_ASSEMBLY NUMBER

COMPONENT_YIELD_FACTOR NUMBER

EFFECTIVITY_DATE DATE

DISABLE_DATE DATE

PLANNING_FACTOR NUMBER

LOW_QUANTITY NUMBER

HIGH_QUANTITY NUMBER

OPERATION_LEAD_TIME_PERCENT NUMBER

WIP_SUPPLY_TYPE NUMBER

FROM_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
TO_END_ITEM_UNIT_NUMBER VARCHAR2 (30)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REFRESH_ID NUMBER

DELETED_FLAG NUMBER

SR_INSTANCE_CODE VARCHAR2 (3)
COMPANY_NAME VARCHAR2 (255)
WIP_ENTITY_NAME VARCHAR2 (240)
ORGANIZATION_CODE VARCHAR2 (7)
OPERATION_SEQ_CODE VARCHAR2 (10)
ROUTING_NAME VARCHAR2 (250)
COMPONENT_NAME VARCHAR2 (250)
ASSEMBLY_ITEM_NAME VARCHAR2 (250)
PRIMARY_COMPONENT_NAME VARCHAR2 (250)
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
ROUTING_SEQUENCE_ID NUMBER

DEPARTMENT_CODE VARCHAR2 (10)
DATA_SOURCE_TYPE VARCHAR2 (10)
BATCH_ID NUMBER

ST_TRANSACTION_ID NUMBER

MESSAGE_ID NUMBER

ERROR_TEXT VARCHAR2 (2000)
PROCESS_FLAG NUMBER

OP_EFFECTIVITY_DATE DATE

SOURCE_PHANTOM_NAME VARCHAR2 (250)
COMPONENT_SCALING_TYPE NUMBER

Query Text

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


SELECT WIP_ENTITY_ID
,      SR_INSTANCE_ID
,      OPERATION_SEQ_NUM
,      COMPONENT_ITEM_ID
,      PRIMARY_COMPONENT_ID
,      SOURCE_PHANTOM_ID
,      RECOMMENDED
,      RECO_DATE_REQUIRED
,      ORGANIZATION_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_PRIORITY
,      DEPARTMENT_ID
,      QUANTITY_PER_ASSEMBLY
,      COMPONENT_YIELD_FACTOR
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      PLANNING_FACTOR
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      OPERATION_LEAD_TIME_PERCENT
,      WIP_SUPPLY_TYPE
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REFRESH_ID
,      DELETED_FLAG
,      SR_INSTANCE_CODE
,      COMPANY_NAME
,      WIP_ENTITY_NAME
,      ORGANIZATION_CODE
,      OPERATION_SEQ_CODE
,      ROUTING_NAME
,      COMPONENT_NAME
,      ASSEMBLY_ITEM_NAME
,      PRIMARY_COMPONENT_NAME
,      ALTERNATE_ROUTING_DESIGNATOR
,      ALTERNATE_BOM_DESIGNATOR
,      ROUTING_SEQUENCE_ID
,      DEPARTMENT_CODE
,      DATA_SOURCE_TYPE
,      BATCH_ID
,      ST_TRANSACTION_ID
,      MESSAGE_ID
,      ERROR_TEXT
,      PROCESS_FLAG
,      OP_EFFECTIVITY_DATE
,      SOURCE_PHANTOM_NAME
,      COMPONENT_SCALING_TYPE
FROM MSC.MSC_ST_JOB_REQUIREMENT_OPS#;

Dependencies

[top of page]

MSC.MSC_ST_JOB_REQUIREMENT_OPS# references the following:

SchemaMSC
TableMSC_ST_JOB_REQUIREMENT_OPS
MSC.MSC_ST_JOB_REQUIREMENT_OPS# is referenced by following:

SchemaAPPS
SynonymMSC_ST_JOB_REQUIREMENT_OPS