[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

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

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