[Home] [Help] [Dependency Information]
Object Name: | ITG_LPI_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ITG.ITG_LPI_LINES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
APPS.ITG_LPI_LINES_V is not referenced by any database object
|
|
|