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

VIEW: APPS.MRP_FLP_SUPPLY_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Transaction identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
ORDER_DATE DATE
Yes Supply date
SUPPLY_QUANTITY NUMBER
Yes Supply quantity
ORDER_TYPE NUMBER
Yes Order type code
NEW_PROCESSING_DAYS NUMBER

Repetitive schedule processing days
ORDER_NAME VARCHAR2 (80) Yes Order type text
DISPOSITION VARCHAR2 (240)
Disposition
PROJECT_NUMBER VARCHAR2 (4000)
Project number
TASK_NUMBER VARCHAR2 (4000)
Task number
ITEM_ORG VARCHAR2 (44)
Item and organization concatenated together
DESCRIPTION VARCHAR2 (20)
Item description
UNIT_NUMBER VARCHAR2 (30)
unit number
Query Text

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


SELECT TRANSACTION_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      ORDER_DATE
,      SUPPLY_QUANTITY
,      ORDER_TYPE
,      NEW_PROCESSING_DAYS
,      ORDER_NAME
,      DISPOSITION
,      PROJECT_NUMBER
,      TASK_NUMBER
,      ITEM_ORG
,      DESCRIPTION
,      UNIT_NUMBER
FROM APPS.MRP_FLP_SUPPLY_V;

Dependencies

[top of page]

APPS.MRP_FLP_SUPPLY_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
PL/SQL PackageMRP_GET_PROJECT - show dependent code
SynonymMRP_ITEM_PURCHASE_ORDERS
SynonymMRP_RECOMMENDATIONS
SynonymMRP_SYSTEM_ITEMS
ViewMTL_ITEM_FLEXFIELDS
SynonymMTL_PARAMETERS
SynonymWIP_ENTITIES

APPS.MRP_FLP_SUPPLY_V is not referenced by any database object