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_LINES_V

Object Details

Object Name:	ITG_LPI_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ITG.ITG_LPI_LINES_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
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes
AMOUNT_EXTENDED_T_AMOUNT	NUMBER
AMOUNT_EXTENDED_T_CURR_CODE	VARCHAR2	(15)	Yes
AMOUNT_EXTENDED_T_LOOKUP_CODE	VARCHAR2	(2)
AMOUNT_EXTENDED_F_AMOUNT	NUMBER
AMOUNT_EXTENDED_F_CURR_CODE	VARCHAR2	(15)	Yes
AMOUNT_EXTENDED_F_LOOKUP_CODE	VARCHAR2	(2)
OPERAMT_F_UNITPRICE	NUMBER
OPERAMT_UNIT_F_CURRENCY_CODE	VARCHAR2	(15)	Yes
OPERAMT_UNIT_F_QUANTITY	NUMBER
OPERAMT_UNIT_F_UOMCODE	VARCHAR2	(3)	Yes
OPERAMT_T_UNITPRICE	NUMBER
OPERAMT_UNIT_T_CURRENCY_CODE	VARCHAR2	(15)	Yes
OPERAMT_UNIT_T_QUANTITY	NUMBER
OPERAMT_UNIT_T_UOMCODE	VARCHAR2	(3)	Yes
QUANTITY_ITEM_QUANTITY	NUMBER
QUANTITY_ITEM_UOMCODE	VARCHAR2	(3)	Yes
GLNOMACCT	VARCHAR2	(25)
INVLINENUM	VARCHAR2	(40)
COSTCENTER	VARCHAR2	(25)
DESCRIPTN	VARCHAR2	(240)
ELEMENT1	VARCHAR2	(25)
ELEMENT2	VARCHAR2	(25)
ELEMENT3	VARCHAR2	(25)
ELEMENT4	VARCHAR2	(25)
ELEMENT5	VARCHAR2	(25)
ELEMENT6	VARCHAR2	(25)
ELEMENT7	VARCHAR2	(25)
ELEMENT8	VARCHAR2	(25)
ELEMENT9	VARCHAR2	(25)
ELEMENT10	VARCHAR2	(25)
ELEMENT11	VARCHAR2	(25)
ELEMENT12	VARCHAR2	(25)
ELEMENT13	VARCHAR2	(25)
ELEMENT14	VARCHAR2	(25)
ELEMENT15	VARCHAR2	(25)
ELEMENT16	VARCHAR2	(25)
ELEMENT17	VARCHAR2	(25)
ELEMENT18	VARCHAR2	(25)
ELEMENT19	VARCHAR2	(25)
ELEMENT20	VARCHAR2	(25)
ELEMENT21	VARCHAR2	(25)
ELEMENT22	VARCHAR2	(25)
ELEMENT23	VARCHAR2	(25)
ELEMENT24	VARCHAR2	(25)
ELEMENT25	VARCHAR2	(25)
ELEMENT26	VARCHAR2	(25)
ELEMENT27	VARCHAR2	(25)
ELEMENT28	VARCHAR2	(25)
ELEMENT29	VARCHAR2	(25)
ELEMENT30	VARCHAR2	(25)
GLENTITYD	VARCHAR2	(25)
ITEM	VARCHAR2	(4000)
ITEMTYPE	VARCHAR2	(25)
POID	VARCHAR2	(61)
TAXCODE	VARCHAR2	(15)
QUANTITY_UA_RATE_RATE	NUMBER
DATETIME_UA_EFFECTIVE	DATE
UA_EXCHTYPE	VARCHAR2	(30)
UA_ORG	VARCHAR2	(40)

Query Text

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


SELECT INVOICE_ID
,      DISTRIBUTION_LINE_NUMBER
,      AMOUNT_EXTENDED_T_AMOUNT
,      AMOUNT_EXTENDED_T_CURR_CODE
,      AMOUNT_EXTENDED_T_LOOKUP_CODE
,      AMOUNT_EXTENDED_F_AMOUNT
,      AMOUNT_EXTENDED_F_CURR_CODE
,      AMOUNT_EXTENDED_F_LOOKUP_CODE
,      OPERAMT_F_UNITPRICE
,      OPERAMT_UNIT_F_CURRENCY_CODE
,      OPERAMT_UNIT_F_QUANTITY
,      OPERAMT_UNIT_F_UOMCODE
,      OPERAMT_T_UNITPRICE
,      OPERAMT_UNIT_T_CURRENCY_CODE
,      OPERAMT_UNIT_T_QUANTITY
,      OPERAMT_UNIT_T_UOMCODE
,      QUANTITY_ITEM_QUANTITY
,      QUANTITY_ITEM_UOMCODE
,      GLNOMACCT
,      INVLINENUM
,      COSTCENTER
,      DESCRIPTN
,      ELEMENT1
,      ELEMENT2
,      ELEMENT3
,      ELEMENT4
,      ELEMENT5
,      ELEMENT6
,      ELEMENT7
,      ELEMENT8
,      ELEMENT9
,      ELEMENT10
,      ELEMENT11
,      ELEMENT12
,      ELEMENT13
,      ELEMENT14
,      ELEMENT15
,      ELEMENT16
,      ELEMENT17
,      ELEMENT18
,      ELEMENT19
,      ELEMENT20
,      ELEMENT21
,      ELEMENT22
,      ELEMENT23
,      ELEMENT24
,      ELEMENT25
,      ELEMENT26
,      ELEMENT27
,      ELEMENT28
,      ELEMENT29
,      ELEMENT30
,      GLENTITYD
,      ITEM
,      ITEMTYPE
,      POID
,      TAXCODE
,      QUANTITY_UA_RATE_RATE
,      DATETIME_UA_EFFECTIVE
,      UA_EXCHTYPE
,      UA_ORG
FROM APPS.ITG_LPI_LINES_V;

Dependencies

[top of page]

APPS.ITG_LPI_LINES_V references the following:

APPS: AP_INVOICES_ALL; AP_INVOICE_DISTRIBUTIONS_ALL; GL_CODE_COMBINATIONS; GL_SETS_OF_BOOKS; ITG_X_UTILS - show dependent code; MTL_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL

APPS.ITG_LPI_LINES_V is not referenced by any database object