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

VIEW: APPS.MSC_SR_VIEW_EXP_V

Object Details
Object Name: MSC_SR_VIEW_EXP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_SR_VIEW_EXP_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
SOURCING_RULE_ID NUMBER
Yes
SR_RECEIPT_ID NUMBER
Yes
RECEIPT_ORGANIZATION_ID NUMBER

RECEIPT_ORG_INSTANCE_ID NUMBER

SR_INSTANCE_ID NUMBER

SR_SOURCE_ID NUMBER
Yes
SOURCE_TYPE VARCHAR2 (80) Yes
SOURCE_ORGANIZATION_ID NUMBER

SOURCE_ORG_INSTANCE_ID NUMBER

SOURCE_ORGANIZATION_CODE VARCHAR2 (4000)
VENDOR_NAME VARCHAR2 (4000)
VENDOR_SITE VARCHAR2 (4000)
ALLOCATION_PERCENT NUMBER

RANK NUMBER

SHIP_METHOD VARCHAR2 (30)
INTRANSIT_TIME VARCHAR2 (0)
ORG_VENDOR VARCHAR2 (4000)
Query Text

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


SELECT SOURCING_RULE_ID
,      SR_RECEIPT_ID
,      RECEIPT_ORGANIZATION_ID
,      RECEIPT_ORG_INSTANCE_ID
,      SR_INSTANCE_ID
,      SR_SOURCE_ID
,      SOURCE_TYPE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORG_INSTANCE_ID
,      SOURCE_ORGANIZATION_CODE
,      VENDOR_NAME
,      VENDOR_SITE
,      ALLOCATION_PERCENT
,      RANK
,      SHIP_METHOD
,      INTRANSIT_TIME
,      ORG_VENDOR
FROM APPS.MSC_SR_VIEW_EXP_V;

Dependencies

[top of page]

APPS.MSC_SR_VIEW_EXP_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_SR_RECEIPT_ORG
ViewMSC_SR_SOURCE_ORG_V

APPS.MSC_SR_VIEW_EXP_V is not referenced by any database object