[Home] [Help] [Dependency Information]
Object Name: | POR_EXPENDITURE_LOV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.POR_EXPENDITURE_LOV_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
The POR_EXPENDITURE_LOV_V view returns a list of expenditure that allows the user to choose to be the expenditure the purchasing item belongs to.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | Expenditure type |
DESCRIPTION | VARCHAR2 | (250) | Description | |
START_DATE_ACTIVE | DATE | Yes | Active start date | |
END_DATE_ACTIVE | DATE | Active end date |
Cut, paste (and edit) the following text to query this object:
SELECT EXPENDITURE_TYPE
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM APPS.POR_EXPENDITURE_LOV_V;
APPS.POR_EXPENDITURE_LOV_V is not referenced by any database object
|
|
|