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_SP_PO_HEADERS_V

Object Details

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

This view is used to generate XML at po headers level for use in Sync PO message

[View Source]

Columns

Name	Datatype	Length	Mandatory
PO_HEADER_ID	NUMBER		Yes
DATETIME_DOCUMENT	DATE
OPERAMT_EXTENDED	NUMBER
OPERAMT_CURRENCY	VARCHAR2	(15)
POID	VARCHAR2	(20)	Yes
BUYERID	VARCHAR2	(240)
DELIVERTO	VARCHAR2	(60)
NOTES	VARCHAR2	(240)
POENTITY	VARCHAR2	(40)
PORELEASE	VARCHAR2	(0)
POSTATUS	VARCHAR2	(25)
POTYPE	VARCHAR2	(25)	Yes
TAXWHEXMPT	VARCHAR2	(0)
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 PO_HEADER_ID
,      DATETIME_DOCUMENT
,      OPERAMT_EXTENDED
,      OPERAMT_CURRENCY
,      POID
,      BUYERID
,      DELIVERTO
,      NOTES
,      POENTITY
,      PORELEASE
,      POSTATUS
,      POTYPE
,      TAXWHEXMPT
,      TO_PO_INTERNAL
,      TO_MISC
,      TO_APPROVER
,      TO_BUYER
,      TO_PAYABLES
,      TO_RECEIVER
,      TO_SUPPLIER
FROM APPS.ITG_SP_PO_HEADERS_V;

Dependencies

[top of page]

APPS.ITG_SP_PO_HEADERS_V references the following:

APPS: HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; ITG_X_UTILS - show dependent code; PER_PEOPLE_F; PO_HEADERS_ALL

APPS.ITG_SP_PO_HEADERS_V is not referenced by any database object