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


VIEW: APPS.MRPBV_REPLENISHMENT_SOURCES

Object Details
Object Name: MRPBV_REPLENISHMENT_SOURCES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRPBV_REPLENISHMENT_SOURCES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows the source organizations or source suppliers for Sourcing Rules or Bills of Distribution.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE VARCHAR2 (80)
ALLOCATION_PERCENT NUMBER
Yes
RANK NUMBER

SHIPPING_METHOD VARCHAR2 (30)
REPLENISHMENT_SOURCE_ID NUMBER
Yes
REPLENISHMENT_DESTINATION_ID NUMBER
Yes
SOURCE_ORGANIZATION_ID NUMBER

SUPPLIER_ID NUMBER

SUPPLIER_SITE_ID NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
Query Text

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


SELECT SOURCE_TYPE
,      ALLOCATION_PERCENT
,      RANK
,      SHIPPING_METHOD
,      REPLENISHMENT_SOURCE_ID
,      REPLENISHMENT_DESTINATION_ID
,      SOURCE_ORGANIZATION_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.MRPBV_REPLENISHMENT_SOURCES;

Dependencies

[top of page]

APPS.MRPBV_REPLENISHMENT_SOURCES references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_SR_RECEIPT_ORG
SynonymMRP_SR_SOURCE_ORG
SynonymMTL_INTERORG_SHIP_METHODS

APPS.MRPBV_REPLENISHMENT_SOURCES is not referenced by any database object