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

VIEW: APPS.MRPFV_REPLENISHMENT_SOURCES

Object Details
Object Name: MRPFV_REPLENISHMENT_SOURCES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRPFV_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)
SOURCE_ORGANIZATION_CODE VARCHAR2 (3)
SOURCE_ORGANIZATION_NAME VARCHAR2 (240)
SUPPLIER VARCHAR2 (240)
SUPPLIER_SITE VARCHAR2 (15)
ALLOCATION_PERCENT NUMBER
Yes
RANK NUMBER

SHIPPING_METHOD VARCHAR2 (30)
INTRANSIT_TIME NUMBER

_DF CHAR (28)
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
,      SOURCE_ORGANIZATION_CODE
,      SOURCE_ORGANIZATION_NAME
,      SUPPLIER
,      SUPPLIER_SITE
,      ALLOCATION_PERCENT
,      RANK
,      SHIPPING_METHOD
,      INTRANSIT_TIME
,      _DF
,      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.MRPFV_REPLENISHMENT_SOURCES;

Dependencies

[top of page]

APPS.MRPFV_REPLENISHMENT_SOURCES references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
ViewMFG_LOOKUPS
SynonymMRP_SR_RECEIPT_ORG
SynonymMRP_SR_SOURCE_ORG
SynonymMTL_INTERORG_SHIP_METHODS
SynonymMTL_PARAMETERS
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.MRPFV_REPLENISHMENT_SOURCES is not referenced by any database object