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_LINE_DETAILS_V

Object Details

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

View Type

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

The POR_VIEW_LINE_DETAILS_V view provides data to POR_VIEW_LINE_DETAILS_R region on View Line Details 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
ITEM_ID	NUMBER			Item unique identifier
ITEM_NUMBER	VARCHAR2	(40)		Item number
ITEM_REVISION	VARCHAR2	(3)		Item revision
DESCRIPTION	VARCHAR2	(240)	Yes	Item description
CATEGORY_ID	NUMBER			Item category unique identifier
CATEGORY	VARCHAR2	(163)		Item category
CATEGORY_DESCRIPTION	VARCHAR2	(240)		Item category description
NEED_BY_DATE	VARCHAR2	(75)		Standard Who column
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)		Unit of measure
UNIT_PRICE	NUMBER			Unit price in functional currency
RATE_PER_UNIT	NUMBER			Unit price in functional currency
SERVICE_COST	NUMBER			Unit price in functional currency
QUANTITY	NUMBER			Quantity ordered
TAX_EXEMPT_FLAG	VARCHAR2	(30)		Indicates whether the item is tax exempted or not
NEW_SUPPLIER_FLAG	VARCHAR2	(80)	Yes	Indicates whether the supplier is new or not
SUGGESTED_VENDOR_NAME	VARCHAR2	(240)		Suggested vender name
SUGGESTED_VENDOR_PRODUCT_CODE	VARCHAR2	(25)		Suggested supplier product number
SUGGESTED_VENDOR_LOCATION	VARCHAR2	(240)		Suggested supplier site name
SUGGESTED_VENDOR_CONTACT	VARCHAR2	(80)		Suggested supplier contacted name
SUGGESTED_VENDOR_PHONE	VARCHAR2	(25)		Suggested supplier phone number
SUPPLIER_NUMBER	VARCHAR2	(30)		Supplier number
SUPPLIER_DUNS	VARCHAR2	(60)		Data Universal Numbering System Code
MANUFACTURER	VARCHAR2	(240)		Manufacturer name
MANUFACTURER_PART_NUMBER	VARCHAR2	(150)		Manufacturer part number
REQUESTER_ID	NUMBER	(9)	Yes	Requester unique identifier
REQUESTER	VARCHAR2	(240)		Requester name
REQUESTER_EMAIL	VARCHAR2	(240)		Requester email
REQUESTER_PHONE	VARCHAR2	(60)		Requester phone
REQUESTER_FAX	VARCHAR2	(60)		Requester fax
DELIVER_TO_LOCATION_ID	NUMBER			Deliver-to location unique identifier
LOCATION_CODE	VARCHAR2	(60)	Yes	Location type
DELIVER_TO_ORG_ID	NUMBER			Deliver-to organization unique identifier
ORGANIZATION_CODE	VARCHAR2	(3)		Organization type
INV_REPLENISHMENT_FLAG	VARCHAR2	(80)	Yes	Indicates whether the inventory is replenished or not
DESTINATION_SUBINVENTORY	VARCHAR2	(10)		Destination subinventory name
PROJECT_ID	NUMBER			Project unique identifier
PROJECT	VARCHAR2	(25)		Project name
TASK_ID	NUMBER			Task unique identifier
TASK_NAME	VARCHAR2	(278)		Task name
EXPENDITURE_TYPE	VARCHAR2	(30)		Expenditure type
EXPENDITURE_ORG_ID	NUMBER			Expenditure prganization unique identifier
EXPENDITURE_ORG	VARCHAR2	(240)		Expenditure organization name
EXPENDITURE_ITEM_DATE	VARCHAR2	(75)		Expenditure item date
NOTE_TO_APPROVER	VARCHAR2	(4000)		Note to approver
NOTE_TO_AGENT	VARCHAR2	(480)		Note to buyer
NOTE_TO_RECEIVER	VARCHAR2	(480)		Note to receiver
NOTE_TO_VENDOR	VARCHAR2	(480)		Note to supplier
LINE_TOTAL	VARCHAR2	(4000)		Line total
CURRENCY_CODE	VARCHAR2	(15)		Unique identifier for the currency
HAZARD_CLASS_ID	NUMBER			Hazard class unique identifier
HAZARD_CLASS	VARCHAR2	(40)		Hazard class
LINE_NUM	NUMBER		Yes	Line number
LINE_TYPE_ID	NUMBER		Yes	Line type identifier
LINE_TYPE	VARCHAR2	(25)	Yes	Line type
SOURCE_DOC_NUM	VARCHAR2	(20)		source document number
SOURCE_DOC_LINE_NUM	NUMBER			Source document line number
SOURCE_DOC_TYPE_CODE	VARCHAR2	(25)		Source document type
UNSPSC_CODE	VARCHAR2	(30)		Standard Product and Service Code
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
PCARD_FLAG	VARCHAR2	(1)		Unused
CHARGE_ACCOUNT	VARCHAR2	(155)		Charge account
CATALOG_TYPE	VARCHAR2	(30)		Catalog type
PO_NUMBER	VARCHAR2	(20)		PO number
PO_STATUS	VARCHAR2	(80)		PO status
BUYER	VARCHAR2	(240)		Buyer name

Query Text

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


SELECT REQUISITION_LINE_ID
,      REQUISITION_HEADER_ID
,      ITEM_ID
,      ITEM_NUMBER
,      ITEM_REVISION
,      DESCRIPTION
,      CATEGORY_ID
,      CATEGORY
,      CATEGORY_DESCRIPTION
,      NEED_BY_DATE
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_PRICE
,      RATE_PER_UNIT
,      SERVICE_COST
,      QUANTITY
,      TAX_EXEMPT_FLAG
,      NEW_SUPPLIER_FLAG
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_PRODUCT_CODE
,      SUGGESTED_VENDOR_LOCATION
,      SUGGESTED_VENDOR_CONTACT
,      SUGGESTED_VENDOR_PHONE
,      SUPPLIER_NUMBER
,      SUPPLIER_DUNS
,      MANUFACTURER
,      MANUFACTURER_PART_NUMBER
,      REQUESTER_ID
,      REQUESTER
,      REQUESTER_EMAIL
,      REQUESTER_PHONE
,      REQUESTER_FAX
,      DELIVER_TO_LOCATION_ID
,      LOCATION_CODE
,      DELIVER_TO_ORG_ID
,      ORGANIZATION_CODE
,      INV_REPLENISHMENT_FLAG
,      DESTINATION_SUBINVENTORY
,      PROJECT_ID
,      PROJECT
,      TASK_ID
,      TASK_NAME
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ORG
,      EXPENDITURE_ITEM_DATE
,      NOTE_TO_APPROVER
,      NOTE_TO_AGENT
,      NOTE_TO_RECEIVER
,      NOTE_TO_VENDOR
,      LINE_TOTAL
,      CURRENCY_CODE
,      HAZARD_CLASS_ID
,      HAZARD_CLASS
,      LINE_NUM
,      LINE_TYPE_ID
,      LINE_TYPE
,      SOURCE_DOC_NUM
,      SOURCE_DOC_LINE_NUM
,      SOURCE_DOC_TYPE_CODE
,      UNSPSC_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PCARD_FLAG
,      CHARGE_ACCOUNT
,      CATALOG_TYPE
,      PO_NUMBER
,      PO_STATUS
,      BUYER
FROM APPS.POR_VIEW_LINE_DETAILS_V;

Dependencies

[top of page]

APPS.POR_VIEW_LINE_DETAILS_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMETERS; FND_CURRENCY - show dependent code; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; GL_CODE_COMBINATIONS_KFV; GL_SETS_OF_BOOKS; HR_EMPLOYEES_CURRENT_V; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MO_GLOBAL - show dependent code; MTL_CATEGORIES_KFV; MTL_SYSTEM_ITEMS; ORG_ORGANIZATION_DEFINITIONS; PA_ORGANIZATIONS_EXPEND_V; PA_PROJECTS; PA_TASKS_EXPEND_V; PA_TASK_UTILS - show dependent code; PA_UTILS4 - show dependent code; PO_HAZARD_CLASSES; PO_HEADERS; PO_LINE_LOCATIONS; PO_LINE_TYPES; PO_LOOKUP_CODES; PO_REQUISITION_HEADERS; PO_REQUISITION_LINES; PO_REQ_DISTRIBUTIONS; PO_VENDORS

APPS.POR_VIEW_LINE_DETAILS_V is not referenced by any database object