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

VIEW: MRP.MRP_ITEM_SOURCING#

Object Details
Object Name: MRP_ITEM_SOURCING#
Object Type: VIEW
Owner: MRP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPILE_DESIGNATOR VARCHAR2 (10) Yes
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SOURCE_ORGANIZATION_ID NUMBER

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

EFFECTIVE_DATE DATE

LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
DISABLE_DATE DATE

ALLOCATION_PERCENT NUMBER

RANK NUMBER

QUANTITY NUMBER

SOURCE_TYPE NUMBER

AVG_TRANSIT_LEAD_TIME NUMBER

SOURCING_RULE_ID NUMBER

ASSIGNMENT_ID NUMBER
Yes
ASSIGNMENT_SET_ID NUMBER
Yes
ASSIGNMENT_TYPE NUMBER
Yes
SOURCING_RULE_TYPE NUMBER
Yes
SHIP_METHOD VARCHAR2 (30)
LAST_UPDATE_LOGIN NUMBER

HISTORICAL_ALLOC_QTY NUMBER (30)
Query Text

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


SELECT COMPILE_DESIGNATOR
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SOURCE_ORGANIZATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      EFFECTIVE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      DISABLE_DATE
,      ALLOCATION_PERCENT
,      RANK
,      QUANTITY
,      SOURCE_TYPE
,      AVG_TRANSIT_LEAD_TIME
,      SOURCING_RULE_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_SET_ID
,      ASSIGNMENT_TYPE
,      SOURCING_RULE_TYPE
,      SHIP_METHOD
,      LAST_UPDATE_LOGIN
,      HISTORICAL_ALLOC_QTY
FROM MRP.MRP_ITEM_SOURCING#;

Dependencies

[top of page]

MRP.MRP_ITEM_SOURCING# references the following:

SchemaMRP
TableMRP_ITEM_SOURCING
MRP.MRP_ITEM_SOURCING# is referenced by following:

SchemaAPPS
SynonymMRP_ITEM_SOURCING