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.POS_PO_RFQ_LINES_V

Object Details

Object Name:	POS_PO_RFQ_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POS_PO_RFQ_LINES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This View Displays Line Information for RFQ's for all Organizations

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id
PO_HEADER_ID	NUMBER		Yes	Document header unique identifier
PO_LINE_ID	NUMBER		Yes	Document line unique identifier
LINE_NUM	NUMBER		Yes	Line number
LINE_TYPE_ID	NUMBER		Yes	Line type unique identifier
LINE_TYPE	VARCHAR2	(25)		Line Type
ITEM_ID	NUMBER			Item unique identifier
ITEM_NUMBER	VARCHAR2	(4000)		Item Number
ITEM_REVISION	VARCHAR2	(3)		Item Revision
CATEGORY_ID	NUMBER			Item category unique identifier
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)		Unit of measure for the quantity ordered
PRIMARY_UNIT_CLASS	VARCHAR2	(10)		Primary Unit Class
UNIT_PRICE	NUMBER			Unit Price
VENDOR_PRODUCT_NUM	VARCHAR2	(25)		Supplier product number
UN_NUMBER_ID	NUMBER			UN number unique identifier
UN_NUMBER	VARCHAR2	(25)		UN number
HAZARD_CLASS_ID	NUMBER			Hazard class unique identifier
HAZARD_CLASS	VARCHAR2	(40)		Hazard class
MIN_ORDER_QUANTITY	NUMBER			Minimum order quantity for a quotation line
MAX_ORDER_QUANTITY	NUMBER			Maximum order quantity for a quotation line
NOTE_TO_VENDOR	VARCHAR2	(480)		Short note to supplier
FROM_HEADER_ID	NUMBER			Quotation unique identifier
FROM_LINE_ID	NUMBER			Quotation line unique identifier
TAXABLE_FLAG	VARCHAR2	(1)		Indicates whether the document line is taxable or not
QUANTITY	NUMBER			Quantity Ordered
ALLOW_ITEM_DESC_UPDATE_FLAG	VARCHAR2	(1)		Allow item description updates on PO lines
ALLOWED_UNITS_LOOKUP_CODE	NUMBER			Allowed unit of measure conversion type
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Order type lookup code
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)		Flag indicating item may appear on outside operation purchase order
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
CREATED_BY	NUMBER			Standard Who Column
CREATION_DATE	DATE			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER			Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
SHIPMENT_NUM	NUMBER			Shipment line number
SHIP_TO_LOCATION_CODE	VARCHAR2	(60)		Ship To Location Code
SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)		Ship via Lookup Code
PAYMENT_TERMS	VARCHAR2	(240)		Payment Terms
LINE_LOCATION_ID	NUMBER			line location id
SHIP_TO_LOCATION_ID	NUMBER			ship to location id
ORGANIZATION_ID	NUMBER	(15)		Organization Id

Query Text

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


SELECT ROW_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      LINE_NUM
,      LINE_TYPE_ID
,      LINE_TYPE
,      ITEM_ID
,      ITEM_NUMBER
,      ITEM_REVISION
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      UNIT_MEAS_LOOKUP_CODE
,      PRIMARY_UNIT_CLASS
,      UNIT_PRICE
,      VENDOR_PRODUCT_NUM
,      UN_NUMBER_ID
,      UN_NUMBER
,      HAZARD_CLASS_ID
,      HAZARD_CLASS
,      MIN_ORDER_QUANTITY
,      MAX_ORDER_QUANTITY
,      NOTE_TO_VENDOR
,      FROM_HEADER_ID
,      FROM_LINE_ID
,      TAXABLE_FLAG
,      QUANTITY
,      ALLOW_ITEM_DESC_UPDATE_FLAG
,      ALLOWED_UNITS_LOOKUP_CODE
,      ORDER_TYPE_LOOKUP_CODE
,      OUTSIDE_OPERATION_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      SHIPMENT_NUM
,      SHIP_TO_LOCATION_CODE
,      SHIP_VIA_LOOKUP_CODE
,      PAYMENT_TERMS
,      LINE_LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      ORGANIZATION_ID
FROM APPS.POS_PO_RFQ_LINES_V;

Dependencies

[top of page]

APPS.POS_PO_RFQ_LINES_V references the following:

APPS: AP_TERMS; FINANCIALS_SYSTEM_PARAMS_ALL; HR_LOCATIONS_ALL; MTL_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; POS_GET - show dependent code; PO_HAZARD_CLASSES; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_UN_NUMBERS

APPS.POS_PO_RFQ_LINES_V is not referenced by any database object