Skip to content

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

VIEW: MSC.MSC_LOCAL_ID_SUPPLY#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOCAL_ID NUMBER

ST_TRANSACTION_ID NUMBER

INSTANCE_ID NUMBER

ENTITY_NAME VARCHAR2 (80)
DATA_SOURCE_TYPE VARCHAR2 (15)
NUMBER1 NUMBER

NUMBER2 NUMBER

NUMBER3 NUMBER

NUMBER4 NUMBER

NUMBER5 NUMBER

CHAR1 VARCHAR2 (255)
CHAR2 VARCHAR2 (255)
CHAR3 VARCHAR2 (255)
CHAR4 VARCHAR2 (255)
CHAR5 VARCHAR2 (255)
CHAR6 VARCHAR2 (255)
CHAR7 VARCHAR2 (255)
CHAR8 VARCHAR2 (255)
CHAR9 VARCHAR2 (255)
CHAR10 VARCHAR2 (255)
DATE1 DATE

DATE2 DATE

DATE3 DATE

DATE4 DATE

DATE5 DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SOURCE_ORG_ID NUMBER

SOURCE_INVENTORY_ITEM_ID NUMBER

SOURCE_VENDOR_ID NUMBER

SOURCE_VENDOR_SITE_ID NUMBER

SOURCE_TASK_ID NUMBER

SOURCE_FROM_ORGANIZATION_ID NUMBER

SOURCE_SR_MTL_SUPPLY_ID NUMBER

SOURCE_DISPOSITION_ID NUMBER

SOURCE_PROJECT_ID NUMBER

SOURCE_BILL_SEQUENCE_ID NUMBER

SOURCE_ROUTING_SEQUENCE_ID NUMBER

SOURCE_SCHEDULE_GROUP_ID NUMBER

SOURCE_WIP_ENTITY_ID NUMBER

Query Text

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


SELECT LOCAL_ID
,      ST_TRANSACTION_ID
,      INSTANCE_ID
,      ENTITY_NAME
,      DATA_SOURCE_TYPE
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      CHAR9
,      CHAR10
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SOURCE_ORG_ID
,      SOURCE_INVENTORY_ITEM_ID
,      SOURCE_VENDOR_ID
,      SOURCE_VENDOR_SITE_ID
,      SOURCE_TASK_ID
,      SOURCE_FROM_ORGANIZATION_ID
,      SOURCE_SR_MTL_SUPPLY_ID
,      SOURCE_DISPOSITION_ID
,      SOURCE_PROJECT_ID
,      SOURCE_BILL_SEQUENCE_ID
,      SOURCE_ROUTING_SEQUENCE_ID
,      SOURCE_SCHEDULE_GROUP_ID
,      SOURCE_WIP_ENTITY_ID
FROM MSC.MSC_LOCAL_ID_SUPPLY#;

Dependencies

[top of page]

MSC.MSC_LOCAL_ID_SUPPLY# references the following:

SchemaMSC
TableMSC_LOCAL_ID_SUPPLY
MSC.MSC_LOCAL_ID_SUPPLY# is referenced by following:

SchemaAPPS
SynonymMSC_LOCAL_ID_SUPPLY