eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.POR_VIEW_LINES_V

Object Details

Object Name:	POR_VIEW_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.POR_VIEW_LINES_V
Subobject Name:
Status:	VALID

View Type

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

The POR_VIEW_LINES_V view provides data to POR_OD_LINES_R region on Order Detail Page

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUISITION_LINE_ID	NUMBER		Yes	Requisition line unique identifier
REQUISITION_HEADER_ID	NUMBER		Yes	Requisition header unique identifier
CATEGORY	VARCHAR2	(40)		Requisition category
ITEM_NUMBER	VARCHAR2	(40)		Item number
DESCRIPTION	VARCHAR2	(240)	Yes	Item description
NEED_BY_DATE	VARCHAR2	(75)		When the item is needed
CHARGE_ACCOUNT	VARCHAR2	(4000)		Charge account number
PO_NUMBER	VARCHAR2	(61)		PO number
SOURCE_TYPE_CODE	VARCHAR2	(25)	Yes	Source Type Code
ORDER_TYPE	VARCHAR2	(80)		Order Type
QUANTITY	NUMBER			Item quantity
LINE_TOTAL	VARCHAR2	(4000)		Line total
UNIT_OF_MEASURE	VARCHAR2	(25)	Yes	Unit of measure
LINE_NUM	NUMBER		Yes	Line number
UNIT_PRICE	NUMBER			Unit price
SUPPLIER	VARCHAR2	(240)		Supplier name
SUPPLIER_ITEM_NUM	VARCHAR2	(25)		Supplier item number
SUPPLIER_SITE	VARCHAR2	(15)		Supplier site
SUPPLIER_CONTACT	VARCHAR2	(80)		Supplier contact information
REQUESTER	VARCHAR2	(240)		Requester name
DELIVER_TO_LOCATION	VARCHAR2	(60)	Yes	Deliver to location
INVENTORY_REPLENISHMENT	VARCHAR2	(1)		Indicates whether inventory replenishment or not
SUBINVENTORY	VARCHAR2	(10)		Destination subinventory
PARENT_REQ_LINE_ID	NUMBER			Parent requisition line identifier
PROJECT_NUMBER	VARCHAR2	(4000)		Project number
TASK	VARCHAR2	(4000)		Task name
EXPENDITURE_TYPE	VARCHAR2	(4000)		Expenditure type
BUYER	VARCHAR2	(240)		Buyer

Query Text

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


SELECT REQUISITION_LINE_ID
,      REQUISITION_HEADER_ID
,      CATEGORY
,      ITEM_NUMBER
,      DESCRIPTION
,      NEED_BY_DATE
,      CHARGE_ACCOUNT
,      PO_NUMBER
,      SOURCE_TYPE_CODE
,      ORDER_TYPE
,      QUANTITY
,      LINE_TOTAL
,      UNIT_OF_MEASURE
,      LINE_NUM
,      UNIT_PRICE
,      SUPPLIER
,      SUPPLIER_ITEM_NUM
,      SUPPLIER_SITE
,      SUPPLIER_CONTACT
,      REQUESTER
,      DELIVER_TO_LOCATION
,      INVENTORY_REPLENISHMENT
,      SUBINVENTORY
,      PARENT_REQ_LINE_ID
,      PROJECT_NUMBER
,      TASK
,      EXPENDITURE_TYPE
,      BUYER
FROM APPS.POR_VIEW_LINES_V;

Dependencies

[top of page]

APPS.POR_VIEW_LINES_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMETERS; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; GL_SETS_OF_BOOKS; HR_GENERAL - show dependent code; HR_LOCATIONS; MTL_CATEGORIES; MTL_SYSTEM_ITEMS_KFV; MTL_UNITS_OF_MEASURE_VL; OE_ORDER_HEADERS; PER_ALL_PEOPLE_F; POR_VIEW_REQS_PKG - show dependent code; PO_HEADERS; PO_LINE_LOCATIONS; PO_LOOKUP_CODES; PO_RELEASES; PO_REQUISITION_HEADERS; PO_REQUISITION_LINES; PO_VENDORS; PO_VENDOR_SITES

APPS.POR_VIEW_LINES_V is not referenced by any database object