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

Object Details

Object Name:	ITG_REQ_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ITG.ITG_REQ_LINES_V
Subobject Name:
Status:	VALID

View Type

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

This view is used to generate the XML at the requisition lines level

[View Source]

Columns

Name	Datatype	Length	Mandatory
REQ_HEADER_ID	NUMBER		Yes
REQ_LINE_ID	NUMBER		Yes
DATETIME_NEED_BY_DATE	DATE
QUANTITY_ORDERED	NUMBER
UOM_CODE	VARCHAR2	(3)	Yes
OPERAMT_UNIT_PRICE	NUMBER
OPERAMT_CURRENCY_CODE	VARCHAR2	(15)
OPERAMT_QUANTITY	NUMBER
REQLINENUM	VARCHAR2	(40)
BUYERID	VARCHAR2	(240)
COMMODITY	VARCHAR2	(4000)
DELIVERTO	VARCHAR2	(30)
HAZARDMATL	VARCHAR2	(40)
ITEMRV	VARCHAR2	(3)
ITEMX	VARCHAR2	(25)
NOTES	VARCHAR2	(480)
POENTITY	NUMBER
PROPERTY_1	VARCHAR2	(25)
PROPERTY_2	VARCHAR2	(40)
SITELEVEL_1	VARCHAR2	(240)
SITELEVEL_2	VARCHAR2	(10)
DESCRIPTN	VARCHAR2	(240)	Yes
ITEM	VARCHAR2	(4000)
LINE_UA_EXPENSE	VARCHAR2	(1)
LINE_UA_ATTRIBUTE	VARCHAR2	(150)
LINE_UA_ATTRIBUTE1	VARCHAR2	(150)
LINE_UA_ATTRIBUTE2	VARCHAR2	(150)
LINE_UA_ATTRIBUTE3	VARCHAR2	(150)
LINE_UA_ATTRIBUTE4	VARCHAR2	(150)
LINE_UA_ATTRIBUTE5	VARCHAR2	(150)
LINE_UA_ATTRIBUTE6	VARCHAR2	(150)
LINE_UA_ATTRIBUTE7	VARCHAR2	(150)
LINE_UA_ATTRIBUTE8	VARCHAR2	(150)
LINE_UA_ATTRIBUTE9	VARCHAR2	(150)
LINE_UA_ATTRIBUTE10	VARCHAR2	(150)
LINE_UA_ATTRIBUTE11	VARCHAR2	(150)
LINE_UA_ATTRIBUTE12	VARCHAR2	(150)
LINE_UA_ATTRIBUTE13	VARCHAR2	(150)
LINE_UA_ATTRIBUTE14	VARCHAR2	(150)
LINE_UA_ATTRIBUTE15	VARCHAR2	(150)
EMPLOYEE_NAME	VARCHAR2	(60)	Yes
EMPLOYEE_PARTNID	VARCHAR2	(30)
EMPLOYEE_PARTNRTYPE	CHAR	(8)
EMPLOYEE_PARTNRIDX	VARCHAR2	(40)
EMP_UA_BILL_TO_SITE_FLAG	VARCHAR2	(30)
EMP_UA_SHIP_TO_SITE_FLAG	VARCHAR2	(30)
EMP_UA_RECV_SITE_FLAG	VARCHAR2	(30)
EMPLOYEE_ADDR_LINE1	VARCHAR2	(240)
EMPLOYEE_ADDR_LINE2	VARCHAR2	(240)
EMPLOYEE_ADDR_LINE3	VARCHAR2	(240)
EMPLOYEE_ADDR_ADDRTYPE	CHAR	(8)
EMPLOYEE_ADDR_CITY	VARCHAR2	(30)
EMPLOYEE_ADDR_COUNTRY	VARCHAR2	(60)
EMPLOYEE_ADDR_COUNTY	VARCHAR2	(4000)
EMPLOYEE_ADDR_DESCRIPTN	VARCHAR2	(240)
EMPLOYEE_ADDR_POSTALCODE	VARCHAR2	(30)
EMPLOYEE_ADDR_STATEPROVN	VARCHAR2	(4000)
EMPLOYEE_ADDR_TELEPHONE1	VARCHAR2	(60)
EMPLOYEE_ADDR_TELEPHONE2	VARCHAR2	(60)
EMPLOYEE_ADDR_TELEPHONE3	VARCHAR2	(60)
EMPLOYEE_CONTACT_NAME	VARCHAR2	(30)
EMPLOYEE_CONTACT_EMAIL	VARCHAR2	(240)
EMPLOYEE_CONTACT_TELEPHONE1	VARCHAR2	(4000)
SHIPTO_NAME	VARCHAR2	(240)
SHIPTO_PARTNRID	VARCHAR2	(3)
SHIPTO_PARTNRTYPE	CHAR	(6)
SHIPTO_PARTNRIDX	VARCHAR2	(40)
SHIPTO_TAXEXEMPT	VARCHAR2	(1)
SHIPTO_TAXID	VARCHAR2	(4000)
SHIPTO_UA_BILLFLG	VARCHAR2	(30)
SHIPTO_UA_SHIPFLG	VARCHAR2	(30)
SHIPTO_UA_RECFLG	VARCHAR2	(30)
SHIPTO_ADDR_LINE1	VARCHAR2	(240)
SHIPTO_ADDR_LINE2	VARCHAR2	(240)
SHIPTO_ADDR_LINE3	VARCHAR2	(240)
SHIPTO_ADDR_ADDRTYPE	CHAR	(9)
SHIPTO_ADDR_CITY	VARCHAR2	(30)
SHIPTO_ADDR_COUNTRY	VARCHAR2	(60)
SHIPTO_ADDR_COUNTY	VARCHAR2	(4000)
SHIPTO_ADDR_DESCRIPTN	VARCHAR2	(240)
SHIPTO_ADDR_POSTALCODE	VARCHAR2	(30)
SHIPTO_ADDR_STATEPROVN	VARCHAR2	(4000)
SHIPTO_ADDR_TELEPHONE1	VARCHAR2	(60)
SHIPTO_ADDR_TELEPHONE2	VARCHAR2	(60)
SHIPTO_ADDR_TELEPHONE3	VARCHAR2	(60)
TO_PO_INTERNAL	VARCHAR2	(0)
TO_MISC	VARCHAR2	(0)
TO_APPROVER	VARCHAR2	(0)
TO_BUYER	VARCHAR2	(0)
TO_PAYABLES	VARCHAR2	(0)
TO_RECEIVER	VARCHAR2	(0)
TO_SUPPLIER	VARCHAR2	(0)

Query Text

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


SELECT REQ_HEADER_ID
,      REQ_LINE_ID
,      DATETIME_NEED_BY_DATE
,      QUANTITY_ORDERED
,      UOM_CODE
,      OPERAMT_UNIT_PRICE
,      OPERAMT_CURRENCY_CODE
,      OPERAMT_QUANTITY
,      REQLINENUM
,      BUYERID
,      COMMODITY
,      DELIVERTO
,      HAZARDMATL
,      ITEMRV
,      ITEMX
,      NOTES
,      POENTITY
,      PROPERTY_1
,      PROPERTY_2
,      SITELEVEL_1
,      SITELEVEL_2
,      DESCRIPTN
,      ITEM
,      LINE_UA_EXPENSE
,      LINE_UA_ATTRIBUTE
,      LINE_UA_ATTRIBUTE1
,      LINE_UA_ATTRIBUTE2
,      LINE_UA_ATTRIBUTE3
,      LINE_UA_ATTRIBUTE4
,      LINE_UA_ATTRIBUTE5
,      LINE_UA_ATTRIBUTE6
,      LINE_UA_ATTRIBUTE7
,      LINE_UA_ATTRIBUTE8
,      LINE_UA_ATTRIBUTE9
,      LINE_UA_ATTRIBUTE10
,      LINE_UA_ATTRIBUTE11
,      LINE_UA_ATTRIBUTE12
,      LINE_UA_ATTRIBUTE13
,      LINE_UA_ATTRIBUTE14
,      LINE_UA_ATTRIBUTE15
,      EMPLOYEE_NAME
,      EMPLOYEE_PARTNID
,      EMPLOYEE_PARTNRTYPE
,      EMPLOYEE_PARTNRIDX
,      EMP_UA_BILL_TO_SITE_FLAG
,      EMP_UA_SHIP_TO_SITE_FLAG
,      EMP_UA_RECV_SITE_FLAG
,      EMPLOYEE_ADDR_LINE1
,      EMPLOYEE_ADDR_LINE2
,      EMPLOYEE_ADDR_LINE3
,      EMPLOYEE_ADDR_ADDRTYPE
,      EMPLOYEE_ADDR_CITY
,      EMPLOYEE_ADDR_COUNTRY
,      EMPLOYEE_ADDR_COUNTY
,      EMPLOYEE_ADDR_DESCRIPTN
,      EMPLOYEE_ADDR_POSTALCODE
,      EMPLOYEE_ADDR_STATEPROVN
,      EMPLOYEE_ADDR_TELEPHONE1
,      EMPLOYEE_ADDR_TELEPHONE2
,      EMPLOYEE_ADDR_TELEPHONE3
,      EMPLOYEE_CONTACT_NAME
,      EMPLOYEE_CONTACT_EMAIL
,      EMPLOYEE_CONTACT_TELEPHONE1
,      SHIPTO_NAME
,      SHIPTO_PARTNRID
,      SHIPTO_PARTNRTYPE
,      SHIPTO_PARTNRIDX
,      SHIPTO_TAXEXEMPT
,      SHIPTO_TAXID
,      SHIPTO_UA_BILLFLG
,      SHIPTO_UA_SHIPFLG
,      SHIPTO_UA_RECFLG
,      SHIPTO_ADDR_LINE1
,      SHIPTO_ADDR_LINE2
,      SHIPTO_ADDR_LINE3
,      SHIPTO_ADDR_ADDRTYPE
,      SHIPTO_ADDR_CITY
,      SHIPTO_ADDR_COUNTRY
,      SHIPTO_ADDR_COUNTY
,      SHIPTO_ADDR_DESCRIPTN
,      SHIPTO_ADDR_POSTALCODE
,      SHIPTO_ADDR_STATEPROVN
,      SHIPTO_ADDR_TELEPHONE1
,      SHIPTO_ADDR_TELEPHONE2
,      SHIPTO_ADDR_TELEPHONE3
,      TO_PO_INTERNAL
,      TO_MISC
,      TO_APPROVER
,      TO_BUYER
,      TO_PAYABLES
,      TO_RECEIVER
,      TO_SUPPLIER
FROM APPS.ITG_REQ_LINES_V;

Dependencies

[top of page]

APPS.ITG_REQ_LINES_V references the following:

APPS: GL_SETS_OF_BOOKS; HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_LOCATIONS_ALL; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; ITG_X_UTILS - show dependent code; MTL_CATEGORIES; MTL_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; ORG_ORGANIZATION_DEFINITIONS; PER_PEOPLE_F; PO_HAZARD_CLASSES_TL; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; PO_UN_NUMBERS_TL

APPS.ITG_REQ_LINES_V is not referenced by any database object