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

VIEW: APPS.MRP_SOURCES_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ORGANIZATION_ID NUMBER

Organization identifier
ASSIGNMENT_TYPE NUMBER

Type of item assignment: Site, Org, Item, etc.
ASSIGNMENT_SET_ID NUMBER
Yes Assignment set identifier
SOURCING_RULE_TYPE NUMBER

Sourcing rule / BOD
SOURCE_ORGANIZATION_ID NUMBER

Sourcing organization identifier
VENDOR_ID NUMBER

Supplier identifier
VENDOR_SITE_ID NUMBER

Supplier site identifier
ALLOCATION_PERCENT NUMBER

Sourcing allocation percentage
RANK NUMBER

Sourcing rank
AVG_TRANSIT_LEAD_TIME NUMBER

Average transit lead time
SHIP_METHOD VARCHAR2 (30)
Shipping method
EFFECTIVE_DATE DATE

Sourcing effective date
DISABLE_DATE DATE

Sourcing disable date
CATEGORY_ID NUMBER

Item category identifier
ASSIGNMENT_ID NUMBER

Sourcing rule assignment identifier
SOURCING_RULE_ID NUMBER

Sourcing rule identifier
SOURCE_TYPE NUMBER

Source type: Transfer / Make / Buy
SOURCING_RULE_NAME VARCHAR2 (50)
Sourcing rule
CUSTOMER_ID NUMBER

Customer identifier
SHIP_TO_SITE_ID NUMBER

Ship to site identifier
TIME_UOM_CODE VARCHAR2 (3)
Unit of measure code for average transit lead time
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ASSIGNMENT_TYPE
,      ASSIGNMENT_SET_ID
,      SOURCING_RULE_TYPE
,      SOURCE_ORGANIZATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ALLOCATION_PERCENT
,      RANK
,      AVG_TRANSIT_LEAD_TIME
,      SHIP_METHOD
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      CATEGORY_ID
,      ASSIGNMENT_ID
,      SOURCING_RULE_ID
,      SOURCE_TYPE
,      SOURCING_RULE_NAME
,      CUSTOMER_ID
,      SHIP_TO_SITE_ID
,      TIME_UOM_CODE
FROM APPS.MRP_SOURCES_V;

Dependencies

[top of page]

APPS.MRP_SOURCES_V references the following:

SchemaAPPS
SynonymMRP_ASSIGNMENT_SETS
ViewMRP_ITEM_SOURCING_LEVELS_V
APPS.MRP_SOURCES_V is referenced by following:

SchemaAPPS
Package BodyCSP_SUPERSESSIONS_PVT - show dependent code
Package BodyCSTPSCEX - show dependent code
Package BodyCTO_ATP_INTERFACE_PK - show dependent code
Package BodyCTO_AUTO_PROCURE_PK - show dependent code
Package BodyCTO_COST_ROLLUP_CONC_PK - show dependent code
Package BodyCTO_MSUTIL_PUB - show dependent code
Package BodyCTO_OSS_SOURCE_PK - show dependent code
Package BodyCTO_UTILITY_PK - show dependent code
ViewMRP_SC_BILL_MAKE_AT_V
ViewMRP_SC_BILL_SF_V
ViewMRP_SC_BILL_WU_V
ViewPO_SOURCE_VENDORS_V
Package BodyPO_SOURCING_SV - show dependent code