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_LINES_V

Object Details

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

View Type

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

The POR_LINES_V returns all the data that is used to define a requisition line. It also includes manufacturer, delivery, organization, buyer information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUISITION_HEADER_ID	NUMBER		Yes	Requisition Header ID
REQUISITION_LINE_ID	NUMBER		Yes	Requisition Line ID
LINE_NUM	NUMBER		Yes	Line Number
LINE_TYPE_ID	NUMBER		Yes	LIne Type ID
LINE_TYPE	VARCHAR2	(25)	Yes	Line Type
ITEM_DESCRIPTION	VARCHAR2	(240)	Yes	Item Description
ITEM_ID	NUMBER			Item ID
ITEM_NUMBER	VARCHAR2	(40)		Item Number
ITEM_REVISION	VARCHAR2	(3)		Item Revision
CATEGORY_ID	NUMBER			Category ID
CATEGORY	VARCHAR2	(163)		Category
CATALOG_TYPE	VARCHAR2	(30)		Catalog Type
CATALOG_SOURCE	VARCHAR2	(30)		Catalog source
CURRENCY_CODE	VARCHAR2	(15)		Currency code
CURRENCY_UNIT_PRICE	NUMBER			currency unit price
NEGOTIATION_NUMBER	VARCHAR2	(83)		Negotiation Number
SO_CREATION_DATE	DATE			SO Creation date
SHIPMENT_NUMBER	VARCHAR2	(4000)		Shipment Number
MANUFACTURER_NAME	VARCHAR2	(240)		Manufacturer name
MANUFACTURER_PART_NUMBER	VARCHAR2	(150)		Manufacturer part number
MUST_USE_SUGG_VENDOR_FLAG	VARCHAR2	(1)		Must use suggested vendor flag
DELIVER_TO_LOCATION_ID	NUMBER			Deliver to location ID
DELIVER_TO_LOCATION	VARCHAR2	(60)	Yes	Deliver to location
DELIVER_TO_ORG_ID	NUMBER			Deliver to org ID
DELIVER_TO_ORG_CODE	VARCHAR2	(3)		Deliver to org code
DESTINATION_SUBINVENTORY	VARCHAR2	(10)		Destination subinventory
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Destination type code
DESTINATION_TYPE	VARCHAR2	(80)		Destination type
REQUESTER_EMAIL	VARCHAR2	(240)		Requester email
REQUESTER_FAX	VARCHAR2	(60)		Requester fax
REQUESTER_ID	NUMBER	(9)	Yes	Requester ID
DELIVER_TO_REQUESTER	VARCHAR2	(240)		Deliever to requester
REQUESTER_PHONE	VARCHAR2	(60)		Requester phone
ENCUMBERED_FLAG	VARCHAR2	(1)		Encumbered Flag
HAZARD_CLASS_ID	NUMBER			Hazard class ID
HAZARD_CLASS	VARCHAR2	(40)		Hazard class
JUSTIFICATION	VARCHAR2	(480)		Justification
MODIFIED_BY_AGENT_FLAG	VARCHAR2	(1)		Modified by agent flag
NEED_BY_DATE	DATE			Need by date
NOTE_TO_AGENT	VARCHAR2	(480)		Note to Agent
NOTE_TO_RECEIVER	VARCHAR2	(480)		Note to Receiver
NOTE_TO_VENDOR	VARCHAR2	(480)		Note to vender
ON_RFQ_FLAG	VARCHAR2	(1)		On RFQ flag
ORG_ID	NUMBER			Org ID
ORG_CODE	VARCHAR2	(3)		Org code
PARENT_REQ_LINE_ID	NUMBER			Parent req line ID
LINE_LOCATION_ID	NUMBER			Line location ID
QUANTITY_CANCELLED	NUMBER			Quantity cancelled
QUANTITY_DELIVERED	NUMBER			Quantity delivered
QUANTITY	NUMBER			Quantity
QUANTITY_RECEIVED	NUMBER			Quantity received
RATE	NUMBER			Rate
RATE_DATE	DATE			Rate date
RATE_TYPE	VARCHAR2	(30)		Rate type
RFQ_REQUIRED_FLAG	VARCHAR2	(1)		RFQ required flag
SOURCE_ORGANIZATION_ID	NUMBER			Source Organization
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code
SOURCE_REQ_LINE_ID	NUMBER			Source req line ID
SOURCE_SUBINVENTORY	VARCHAR2	(10)		Source subinventory
SOURCE_TYPE_CODE	VARCHAR2	(25)	Yes	Source type code
SOURCE_TYPE	VARCHAR2	(80)		Source type
UNSPSC_CODE	VARCHAR2	(30)		UNSPSC code
OTHER_CATEGORY_CODE	VARCHAR2	(30)		Other Category Code
SUGGESTED_BUYER_ID	NUMBER	(9)		Suggested buyer ID
SUGGESTED_BUYER	VARCHAR2	(240)		Suggested buyer
BLANKET_PO_HEADER_ID	NUMBER			Blanket PO header ID
DOCUMENT_NUM	VARCHAR2	(20)		Document Number
BLANKET_PO_LINE_NUM	NUMBER			Blanket PO line number
DOCUMENT_TYPE_CODE	VARCHAR2	(25)		Document type code
DOCUMENT_TYPE	VARCHAR2	(30)		Document type
SUPPLIER_DUNS	VARCHAR2	(60)		Supplier DUNS
SUPPLIER_ITEM_NUMBER	VARCHAR2	(25)		Supplier item number
TAX_STATUS_INDICATOR	VARCHAR2	(30)		Tax status indicator
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		USSGL transaction code
PCARD_FLAG	VARCHAR2	(1)		PCARD flag
TRANSACTION_REASON_CODE	VARCHAR2	(25)		Transaction reason code
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)		Unit of measures lookup code
UNIT_PRICE	NUMBER			Unit price
URGENT_FLAG	VARCHAR2	(1)		Urgent flag
VENDOR_CONTACT_ID	NUMBER			Vendor contact ID
SUGGESTED_VENDOR_CONTACT	VARCHAR2	(80)		Suggested vendor contact
SUGGESTED_VENDOR_PHONE	VARCHAR2	(25)		Suggested vendor phone
VENDOR_ID	NUMBER			Vendor ID
SUGGESTED_VENDOR_NAME	VARCHAR2	(240)		Suggested vendor name
SUGGESTED_VENDOR_LOCATION	VARCHAR2	(240)		Suggested vendor location
VENDOR_SITE_ID	NUMBER			Vendor site ID
VENDOR_SITE_CODE	VARCHAR2	(240)		Vendor site code
NEW_SUPPLIER_FLAG	VARCHAR2	(1)		New supplier flag
AUTO_RECEIVE_FLAG	VARCHAR2	(1)		Auto receive flag
AGENT_RETURN_NOTE	VARCHAR2	(480)		Agent return note
CANCEL_DATE	DATE			Cancel date
CANCEL_FLAG	VARCHAR2	(1)		Cancel flag
CANCEL_FLAG_DISPLAY	VARCHAR2	(80)		Cancel flag display
CANCEL_REASON	VARCHAR2	(240)		Cancel reason
CLOSED_CODE	VARCHAR2	(25)		Closed code
CLOSED_CODE_DISPLAY	VARCHAR2	(80)		Closed code display
CLOSED_DATE	DATE			Closed date
CLOSED_REASON	VARCHAR2	(240)		Closed reason
DESTINATION_CONTEXT	VARCHAR2	(30)		Destination context
UN_NUMBER_ID	NUMBER			UN number ID
ATTRIBUTE1	VARCHAR2	(150)		Attribute 1
ATTRIBUTE2	VARCHAR2	(150)		Attribute 2
ATTRIBUTE3	VARCHAR2	(150)		Attribute 3
ATTRIBUTE4	VARCHAR2	(150)		Attribute 4
ATTRIBUTE5	VARCHAR2	(150)		Attribute 5
ATTRIBUTE6	VARCHAR2	(150)		Attribute 6
ATTRIBUTE7	VARCHAR2	(150)		Attribute 7
ATTRIBUTE8	VARCHAR2	(150)		Attribute 8
ATTRIBUTE9	VARCHAR2	(150)		Attribute 9
ATTRIBUTE10	VARCHAR2	(150)		Attribute 10
ATTRIBUTE11	VARCHAR2	(150)		Attribute 11
ATTRIBUTE12	VARCHAR2	(150)		Attribute 12
ATTRIBUTE13	VARCHAR2	(150)		Attribute 13
ATTRIBUTE14	VARCHAR2	(150)		Attribute 14
ATTRIBUTE15	VARCHAR2	(150)		Attribute 15
ITEM_SOURCE_ID	NUMBER			Item source ID
SUPPLIER_REF_NUMBER	VARCHAR2	(150)		Supplier ref number
TAX_CODE_ID	NUMBER			Tax code ID
TAX_USER_OVERRIDE_FLAG	VARCHAR2	(1)		Tax user override flag
REFERENCE_NUM	VARCHAR2	(25)		Reference Number

Query Text

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


SELECT REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      LINE_NUM
,      LINE_TYPE_ID
,      LINE_TYPE
,      ITEM_DESCRIPTION
,      ITEM_ID
,      ITEM_NUMBER
,      ITEM_REVISION
,      CATEGORY_ID
,      CATEGORY
,      CATALOG_TYPE
,      CATALOG_SOURCE
,      CURRENCY_CODE
,      CURRENCY_UNIT_PRICE
,      NEGOTIATION_NUMBER
,      SO_CREATION_DATE
,      SHIPMENT_NUMBER
,      MANUFACTURER_NAME
,      MANUFACTURER_PART_NUMBER
,      MUST_USE_SUGG_VENDOR_FLAG
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_LOCATION
,      DELIVER_TO_ORG_ID
,      DELIVER_TO_ORG_CODE
,      DESTINATION_SUBINVENTORY
,      DESTINATION_TYPE_CODE
,      DESTINATION_TYPE
,      REQUESTER_EMAIL
,      REQUESTER_FAX
,      REQUESTER_ID
,      DELIVER_TO_REQUESTER
,      REQUESTER_PHONE
,      ENCUMBERED_FLAG
,      HAZARD_CLASS_ID
,      HAZARD_CLASS
,      JUSTIFICATION
,      MODIFIED_BY_AGENT_FLAG
,      NEED_BY_DATE
,      NOTE_TO_AGENT
,      NOTE_TO_RECEIVER
,      NOTE_TO_VENDOR
,      ON_RFQ_FLAG
,      ORG_ID
,      ORG_CODE
,      PARENT_REQ_LINE_ID
,      LINE_LOCATION_ID
,      QUANTITY_CANCELLED
,      QUANTITY_DELIVERED
,      QUANTITY
,      QUANTITY_RECEIVED
,      RATE
,      RATE_DATE
,      RATE_TYPE
,      RFQ_REQUIRED_FLAG
,      SOURCE_ORGANIZATION_ID
,      ORGANIZATION_CODE
,      SOURCE_REQ_LINE_ID
,      SOURCE_SUBINVENTORY
,      SOURCE_TYPE_CODE
,      SOURCE_TYPE
,      UNSPSC_CODE
,      OTHER_CATEGORY_CODE
,      SUGGESTED_BUYER_ID
,      SUGGESTED_BUYER
,      BLANKET_PO_HEADER_ID
,      DOCUMENT_NUM
,      BLANKET_PO_LINE_NUM
,      DOCUMENT_TYPE_CODE
,      DOCUMENT_TYPE
,      SUPPLIER_DUNS
,      SUPPLIER_ITEM_NUMBER
,      TAX_STATUS_INDICATOR
,      USSGL_TRANSACTION_CODE
,      PCARD_FLAG
,      TRANSACTION_REASON_CODE
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_PRICE
,      URGENT_FLAG
,      VENDOR_CONTACT_ID
,      SUGGESTED_VENDOR_CONTACT
,      SUGGESTED_VENDOR_PHONE
,      VENDOR_ID
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_LOCATION
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      NEW_SUPPLIER_FLAG
,      AUTO_RECEIVE_FLAG
,      AGENT_RETURN_NOTE
,      CANCEL_DATE
,      CANCEL_FLAG
,      CANCEL_FLAG_DISPLAY
,      CANCEL_REASON
,      CLOSED_CODE
,      CLOSED_CODE_DISPLAY
,      CLOSED_DATE
,      CLOSED_REASON
,      DESTINATION_CONTEXT
,      UN_NUMBER_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ITEM_SOURCE_ID
,      SUPPLIER_REF_NUMBER
,      TAX_CODE_ID
,      TAX_USER_OVERRIDE_FLAG
,      REFERENCE_NUM
FROM APPS.POR_LINES_V;

Dependencies

[top of page]

APPS.POR_LINES_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MTL_CATEGORIES_KFV; MTL_SYSTEM_ITEMS_KFV; OE_ORDER_HEADERS; ORG_ORGANIZATION_DEFINITIONS; PER_PEOPLE_F; POR_VIEW_REQS_PKG - show dependent code; PO_HAZARD_CLASSES; PO_HEADERS; PO_LINE_TYPES; PO_LOOKUP_CODES; PO_REQUISITION_HEADERS; PO_REQUISITION_LINES; PO_VENDOR_SITES

APPS.POR_LINES_V is not referenced by any database object