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

VIEW: APPS.POR_EXP_ORG_LOV_V

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

View Type

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


This view is used as a base for the Expenditure Organization LOV to chose
the expenditure orgs


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Yes Organization unique identifier
BUSINESS_GROUP_ID NUMBER (15) Yes Business group identifier
NAME VARCHAR2 (240) Yes Expenditure organization identifier
DATE_FROM DATE
Yes From date
DATE_TO DATE

To date
ACTIVE_FLAG CHAR (1)
Flag indicating whether the exp. organization is valid
Query Text

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


SELECT ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      NAME
,      DATE_FROM
,      DATE_TO
,      ACTIVE_FLAG
FROM APPS.POR_EXP_ORG_LOV_V;

Dependencies

[top of page]

APPS.POR_EXP_ORG_LOV_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageMO_GLOBAL - show dependent code
ViewPA_ORGANIZATIONS_EXPEND_V

APPS.POR_EXP_ORG_LOV_V is not referenced by any database object