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

VIEW: APPS.POR_MTL_REASONS_LOV_V

Object Details
Object Name: POR_MTL_REASONS_LOV_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POR_MTL_REASONS_LOV_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


POR_MTL_REASONS_LOV_V is a view for the List of Values which returns the list of all transaction reasons that one may use across organizations in the transaction system. Transaction reasons are user setup data and are always optional in the Inventory Transaction window


[View Source]

Columns
Name Datatype Length Mandatory Comments
REASON_ID NUMBER
Yes Reason Identifier
REASON_NAME VARCHAR2 (30) Yes Reason name
DESCRIPTION VARCHAR2 (240)
Reason Description
Query Text

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


SELECT REASON_ID
,      REASON_NAME
,      DESCRIPTION
FROM APPS.POR_MTL_REASONS_LOV_V;

Dependencies

[top of page]

APPS.POR_MTL_REASONS_LOV_V references the following:

SchemaAPPS
SynonymMTL_TRANSACTION_REASONS

APPS.POR_MTL_REASONS_LOV_V is not referenced by any database object