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


VIEW: APPS.MRP_SR_VIEW_MAKE_AT_V

Object Details
Object Name: MRP_SR_VIEW_MAKE_AT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_SR_VIEW_MAKE_AT_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 Sourcing rule identifier
SR_RECEIPT_ID NUMBER
Yes Identifier used to uniquely identify a row in MRP_SR_RECEIPT_ORG
RECEIPT_ORGANIZATION_ID NUMBER

Receipt organization identifier
SR_SOURCE_ID NUMBER
Yes Identifier used to uniquely identify a row in MRP_SR_SOURCE_ORG
SOURCE_TYPE VARCHAR2 (80) Yes Source type
SOURCE_ORGANIZATION_ID NUMBER

Source organization identifier
SOURCE_ORGANIZATION_CODE VARCHAR2 (3)
Source organization code
VENDOR_NAME VARCHAR2 (240)
Supplier Name
VENDOR_SITE VARCHAR2 (15)
Supplier Site
ALLOCATION_PERCENT NUMBER
Yes Allocation percent defined for each source in split sourcing
RANK NUMBER

Rank of each source in split sourcing
Query Text

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


SELECT SOURCING_RULE_ID
,      SR_RECEIPT_ID
,      RECEIPT_ORGANIZATION_ID
,      SR_SOURCE_ID
,      SOURCE_TYPE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      VENDOR_NAME
,      VENDOR_SITE
,      ALLOCATION_PERCENT
,      RANK
FROM APPS.MRP_SR_VIEW_MAKE_AT_V;

Dependencies

[top of page]

APPS.MRP_SR_VIEW_MAKE_AT_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_SR_RECEIPT_ORG
ViewMRP_SR_SOURCE_ORG_V

APPS.MRP_SR_VIEW_MAKE_AT_V is not referenced by any database object