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

VIEW: APPS.MSC_ST_SALES_CHANNEL

Object Details
Object Name: MSC_ST_SALES_CHANNEL
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


view on stg table to return Sales Channel data


[View Source]

Columns
Name Datatype Length Mandatory Comments
SALES_CHANNEL VARCHAR2 (30)
Sales channel
MEANING VARCHAR2 (80)
Meaning
DESCRIPTION VARCHAR2 (250)
Description
FROM_DATE DATE

From date
TO_DATE DATE

to Date
ENABLED_FLAG NUMBER

Enabled flag
SR_INSTANCE_ID NUMBER

Source Instance Identifier
LAST_UPDATE_DATE VARCHAR2 (3)
Standard Who column
LAST_UPDATED_BY DATE

Standard Who column
CREATION_DATE NUMBER

Standard Who column
CREATED_BY DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
SR_INSTANCE_CODE NUMBER

Source Identifier Code
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
COMPANY_NAME VARCHAR2 (30)
Company Name
BATCH_ID VARCHAR2 (255)
Batch Id
ERROR_TEXT NUMBER

If PROCESS_FLAG is equals to 3 for a record then it will describe the reason for the error
ST_TRANSACTION_ID VARCHAR2 (2000)
Transaction ID generated during pre-processing to uniquely identify a record in the staging table
DATA_SOURCE_TYPE NUMBER

Source Type indicating the source of records
PROCESS_FLAG VARCHAR2 (15)
Processing flag indicating the status of records during pre-processing. 1-New Record, 2- In-Process, 3- Error, 4-Propagated Error, 5- Successfully Processed
MESSAGE_ID NUMBER

This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML
REFRESH_ID NUMBER

Refresh identifier
DELETED_FLAG NUMBER

Deleted flag
ATTRIBUTE_CATEGORY NUMBER

Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
Query Text

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


SELECT SALES_CHANNEL
,      MEANING
,      DESCRIPTION
,      FROM_DATE
,      TO_DATE
,      ENABLED_FLAG
,      SR_INSTANCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      SR_INSTANCE_CODE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COMPANY_NAME
,      BATCH_ID
,      ERROR_TEXT
,      ST_TRANSACTION_ID
,      DATA_SOURCE_TYPE
,      PROCESS_FLAG
,      MESSAGE_ID
,      REFRESH_ID
,      DELETED_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.MSC_ST_SALES_CHANNEL;

Dependencies

[top of page]

APPS.MSC_ST_SALES_CHANNEL references the following:

SchemaAPPS
SynonymMSC_ST_SR_LOOKUPS
APPS.MSC_ST_SALES_CHANNEL is referenced by following:

SchemaAPPS
Package BodyMSC_CL_OTHER_ODS_LOAD - show dependent code