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_HEADERS_V

Object Details

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

View Type

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

This is used to generate XML at requisition headers level

[View Source]

Columns

Name	Datatype	Length	Mandatory
REQ_HEADER_ID	NUMBER		Yes
CREATION_DATE	DATE
SUM_REQLINES	NUMBER
CURRENY_CODE	VARCHAR2	(15)
REQUISITNID	VARCHAR2	(20)	Yes
APPROVED	NUMBER
DESCRIPTN	VARCHAR2	(240)
HDRSTATUS	VARCHAR2	(1)
POENTITY	NUMBER
REQUESTER	VARCHAR2	(30)
HEADER_UA_ATTRIBUTE1	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE2	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE3	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE4	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE5	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE6	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE7	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE8	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE9	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE10	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE11	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE12	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE13	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE14	VARCHAR2	(150)
HEADER_UA_ATTRIBUTE15	VARCHAR2	(150)
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
,      CREATION_DATE
,      SUM_REQLINES
,      CURRENY_CODE
,      REQUISITNID
,      APPROVED
,      DESCRIPTN
,      HDRSTATUS
,      POENTITY
,      REQUESTER
,      HEADER_UA_ATTRIBUTE1
,      HEADER_UA_ATTRIBUTE2
,      HEADER_UA_ATTRIBUTE3
,      HEADER_UA_ATTRIBUTE4
,      HEADER_UA_ATTRIBUTE5
,      HEADER_UA_ATTRIBUTE6
,      HEADER_UA_ATTRIBUTE7
,      HEADER_UA_ATTRIBUTE8
,      HEADER_UA_ATTRIBUTE9
,      HEADER_UA_ATTRIBUTE10
,      HEADER_UA_ATTRIBUTE11
,      HEADER_UA_ATTRIBUTE12
,      HEADER_UA_ATTRIBUTE13
,      HEADER_UA_ATTRIBUTE14
,      HEADER_UA_ATTRIBUTE15
,      TO_PO_INTERNAL
,      TO_MISC
,      TO_APPROVER
,      TO_BUYER
,      TO_PAYABLES
,      TO_RECEIVER
,      TO_SUPPLIER
FROM APPS.ITG_REQ_HEADERS_V;

Dependencies

[top of page]

APPS.ITG_REQ_HEADERS_V references the following:

APPS: GL_SETS_OF_BOOKS; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; ITG_X_UTILS - show dependent code; ORG_ORGANIZATION_DEFINITIONS; PER_PEOPLE_F; PO_REQUISITION_HEADERS_ALL

APPS.ITG_REQ_HEADERS_V is not referenced by any database object