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


VIEW: APPS.MSC_SR_ASSIGNMENTS_V

Object Details
Object Name: MSC_SR_ASSIGNMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_SR_ASSIGNMENTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ASSIGNMENT_ID NUMBER

ASSIGNMENT_SET_ID NUMBER

ASSIGNMENT_TYPE NUMBER

SR_INSTANCE_ID NUMBER

SR_ASSIGNMENT_ID NUMBER

SR_ASSIGNMENT_INSTANCE_ID NUMBER

ORGANIZATION_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (4000)
CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (4000)
SHIP_TO_SITE_ID NUMBER

SHIP_TO_ADDRESS VARCHAR2 (1600)
ENTITY_NAME VARCHAR2 (4000)
DESCRIPTION VARCHAR2 (4000)
SOURCING_RULE_TYPE NUMBER

SOURCING_RULE_TYPE_TEXT VARCHAR2 (80)
SOURCING_RULE_ID NUMBER

SOURCING_RULE_NAME VARCHAR2 (80)
CATEGORY_NAME VARCHAR2 (163)
CATEGORY_SET_ID NUMBER

INVENTORY_ITEM_ID NUMBER

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

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

REGION_CODE VARCHAR2 (244)
COLLECTED_FLAG NUMBER

ALLOCATION_RULE_ID NUMBER

ALLOCATION_RULE_NAME VARCHAR2 (30)
ITEM_TYPE_ID NUMBER

401 - Part condition
ITEM_TYPE_VALUE NUMBER

Null/1 - Usable, 2 - Defective
ITEM_TYPE_VALUE_TEXT VARCHAR2 (4000)
Shows Item part condition: Usable, Defective
Query Text

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


SELECT ROW_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_SET_ID
,      ASSIGNMENT_TYPE
,      SR_INSTANCE_ID
,      SR_ASSIGNMENT_ID
,      SR_ASSIGNMENT_INSTANCE_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      SHIP_TO_SITE_ID
,      SHIP_TO_ADDRESS
,      ENTITY_NAME
,      DESCRIPTION
,      SOURCING_RULE_TYPE
,      SOURCING_RULE_TYPE_TEXT
,      SOURCING_RULE_ID
,      SOURCING_RULE_NAME
,      CATEGORY_NAME
,      CATEGORY_SET_ID
,      INVENTORY_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REGION_ID
,      REGION_CODE
,      COLLECTED_FLAG
,      ALLOCATION_RULE_ID
,      ALLOCATION_RULE_NAME
,      ITEM_TYPE_ID
,      ITEM_TYPE_VALUE
,      ITEM_TYPE_VALUE_TEXT
FROM APPS.MSC_SR_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS.MSC_SR_ASSIGNMENTS_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMSC_DRP_ALLOC_RULES
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_REGIONS
SynonymMSC_SOURCING_RULES
SynonymMSC_SR_ASSIGNMENTS
SynonymMSC_TRADING_PARTNER_SITES

APPS.MSC_SR_ASSIGNMENTS_V is not referenced by any database object