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


VIEW: APPS.MRPBV_MPS_CONSUMPTIONS

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

View Type

A Business Intelligence System view


This shows a relief for a particular production schedule entry.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_NUMBER VARCHAR2 (30)
RELIEF_QUANTITY NUMBER

SCHEDULE_DATE DATE

MPS_ENTRY_ID NUMBER

PURCHASE_ORDER_HEADER_ID NUMBER

SHIPMENT_HEADER_ID NUMBER

REQUISITION_HEADER_ID NUMBER

MFG_ORDER_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

Query Text

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


SELECT LINE_NUMBER
,      RELIEF_QUANTITY
,      SCHEDULE_DATE
,      MPS_ENTRY_ID
,      PURCHASE_ORDER_HEADER_ID
,      SHIPMENT_HEADER_ID
,      REQUISITION_HEADER_ID
,      MFG_ORDER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.MRPBV_MPS_CONSUMPTIONS;

Dependencies

[top of page]

APPS.MRPBV_MPS_CONSUMPTIONS references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_SCHEDULE_CONSUMPTIONS
SynonymMRP_SCHEDULE_DATES
SynonymPO_HEADERS_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymRCV_SHIPMENT_HEADERS
SynonymWIP_ENTITIES

APPS.MRPBV_MPS_CONSUMPTIONS is not referenced by any database object