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_LPI_HEADERS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
INVOICE_ID	NUMBER	(15)	Yes
AMOUNT_DOC_T_INVAMOUNT	NUMBER
AMOUNT_DOC_T_CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT_DOC_T_LOOKUP_TYPE	VARCHAR2	(2)
DOCUMENT_DATETIME	DATE
AMOUNT_DOC_F_AMOUNT	NUMBER
AMOUNT_DOC_F_CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT_DOC_F_LOOKUP_TYPE	VARCHAR2	(2)
GLENTITYS	VARCHAR2	(25)
ORIGREF	VARCHAR2	(50)	Yes
DESCRIPTN	VARCHAR2	(25)
DOCTYPE	VARCHAR2	(25)
LEDGER	VARCHAR2	(30)	Yes
PAYMENT	VARCHAR2	(25)
USERID	VARCHAR2	(100)	Yes
VOUCHER	NUMBER
SUPPLIER_NAME	VARCHAR2	(240)
SUPPLUER_ONETIME	VARCHAR2	(1)
SUPPLIER_PARTNRID	VARCHAR2	(30)	Yes
SUPPLIER_PARTNRTYPE	CHAR	(8)
SUPPLIER_CURRENCY	VARCHAR2	(15)	Yes
SUPPLIER_DESCRIPTN	VARCHAR2	(320)
SUPPLIER_PARTNRIDX	VARCHAR2	(40)
SUPPLIER_TAXEXMPT	VARCHAR2	(1)
SUPPLIER_TAXID	VARCHAR2	(20)
SUPPLIER_UA_USFLAG	VARCHAR2	(1)
SUPPLIER_ADDRESS_LINE1	VARCHAR2	(240)
SUPPLIER_ADDRESS_LINE2	VARCHAR2	(240)
SUPPLIER_ADDRESS_LINE3	VARCHAR2	(240)
SUPPLIER_ADDRESS_CITY	VARCHAR2	(60)
SUPPLIER_ADDRESS_COUNTRY	VARCHAR2	(25)
SUPPLIER_ADDRESS_COUNTY	VARCHAR2	(60)
SUPPLIER_ADDRESS_DESCRIPTN	VARCHAR2	(15)
SUPPLIER_ADDRESS_FAX	VARCHAR2	(26)
SUPPLIER_ADDRESS_POSTALCODE	VARCHAR2	(20)
SUPPLIER_ADDRESS_STATEPROVN	VARCHAR2	(60)
SUPPLIER_ADDRESS_TELEPHONE	VARCHAR2	(26)
SUPPLIER_ADDRESS_UA_VATCODE	VARCHAR2	(0)
SUPPLIER_ADDRESS_UA_PURSITE	VARCHAR2	(1)
SUPPLIER_ADDRESS_UA_PAYSITE	VARCHAR2	(1)
SUPPLIER_ADDRESS_UA_RFQSITE	VARCHAR2	(1)
SUPPLIER_ADDRESS_UA_PCSITE	VARCHAR2	(1)
AMOUNT_DISCNT_T_AMOUNT	NUMBER
AMOUNT_DISCNT_T_CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT_DISCNT_T_LOOKUP_CODE	VARCHAR2	(2)
AMOUNT_DISCNT_F_AMOUNT	NUMBER
AMOUNT_DISCNT_F_CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT_DISCNT_F_LOOKUP_CODE	VARCHAR2	(2)
TERM_DESCRIPTN	VARCHAR2	(240)
TERMID	VARCHAR2	(50)
AMOUNT_TAX_T_AMOUNT	NUMBER
AMOUNT_TAX_T_CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT_TAX_T_LOOKUP_CODE	VARCHAR2	(2)
AMOUNT_TAX_F_AMOUNT	NUMBER
AMOUNT_TAX_F_CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT_TAX_F_LOOKUP_CODE	VARCHAR2	(2)
AMOUNT_TAXBASE_F_AMOUNT	NUMBER
AMOUNT_TAXBASE_F_CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT_TAXBASE_F_LOOKUP_CODE	VARCHAR2	(2)
AMOUNT_TAXBASE_T_AMOUNT	NUMBER
AMOUNT_TAXBASE_T_CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT_TAXBASE_T_LOOKUP_CODE	VARCHAR2	(2)
TAX_TAXCODE	VARCHAR2	(15)

Query Text

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


SELECT INVOICE_ID
,      AMOUNT_DOC_T_INVAMOUNT
,      AMOUNT_DOC_T_CURRENCY_CODE
,      AMOUNT_DOC_T_LOOKUP_TYPE
,      DOCUMENT_DATETIME
,      AMOUNT_DOC_F_AMOUNT
,      AMOUNT_DOC_F_CURRENCY_CODE
,      AMOUNT_DOC_F_LOOKUP_TYPE
,      GLENTITYS
,      ORIGREF
,      DESCRIPTN
,      DOCTYPE
,      LEDGER
,      PAYMENT
,      USERID
,      VOUCHER
,      SUPPLIER_NAME
,      SUPPLUER_ONETIME
,      SUPPLIER_PARTNRID
,      SUPPLIER_PARTNRTYPE
,      SUPPLIER_CURRENCY
,      SUPPLIER_DESCRIPTN
,      SUPPLIER_PARTNRIDX
,      SUPPLIER_TAXEXMPT
,      SUPPLIER_TAXID
,      SUPPLIER_UA_USFLAG
,      SUPPLIER_ADDRESS_LINE1
,      SUPPLIER_ADDRESS_LINE2
,      SUPPLIER_ADDRESS_LINE3
,      SUPPLIER_ADDRESS_CITY
,      SUPPLIER_ADDRESS_COUNTRY
,      SUPPLIER_ADDRESS_COUNTY
,      SUPPLIER_ADDRESS_DESCRIPTN
,      SUPPLIER_ADDRESS_FAX
,      SUPPLIER_ADDRESS_POSTALCODE
,      SUPPLIER_ADDRESS_STATEPROVN
,      SUPPLIER_ADDRESS_TELEPHONE
,      SUPPLIER_ADDRESS_UA_VATCODE
,      SUPPLIER_ADDRESS_UA_PURSITE
,      SUPPLIER_ADDRESS_UA_PAYSITE
,      SUPPLIER_ADDRESS_UA_RFQSITE
,      SUPPLIER_ADDRESS_UA_PCSITE
,      AMOUNT_DISCNT_T_AMOUNT
,      AMOUNT_DISCNT_T_CURRENCY_CODE
,      AMOUNT_DISCNT_T_LOOKUP_CODE
,      AMOUNT_DISCNT_F_AMOUNT
,      AMOUNT_DISCNT_F_CURRENCY_CODE
,      AMOUNT_DISCNT_F_LOOKUP_CODE
,      TERM_DESCRIPTN
,      TERMID
,      AMOUNT_TAX_T_AMOUNT
,      AMOUNT_TAX_T_CURRENCY_CODE
,      AMOUNT_TAX_T_LOOKUP_CODE
,      AMOUNT_TAX_F_AMOUNT
,      AMOUNT_TAX_F_CURRENCY_CODE
,      AMOUNT_TAX_F_LOOKUP_CODE
,      AMOUNT_TAXBASE_F_AMOUNT
,      AMOUNT_TAXBASE_F_CURRENCY_CODE
,      AMOUNT_TAXBASE_F_LOOKUP_CODE
,      AMOUNT_TAXBASE_T_AMOUNT
,      AMOUNT_TAXBASE_T_CURRENCY_CODE
,      AMOUNT_TAXBASE_T_LOOKUP_CODE
,      TAX_TAXCODE
FROM APPS.ITG_LPI_HEADERS_V;

Dependencies

[top of page]

APPS.ITG_LPI_HEADERS_V references the following:

APPS: AP_INVOICES_ALL; AP_TERMS; FND_GLOBAL - show dependent code; FND_USER; GL_CODE_COMBINATIONS; GL_SETS_OF_BOOKS; ITG_X_UTILS - show dependent code; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.ITG_LPI_HEADERS_V is not referenced by any database object