[Home] [Help] [Dependency Information]
Object Name: | IGI_RECOVERABLE_LINES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGI.IGI_RECOVERABLE_LINES |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
IGI_RECOVERABLE_LINES is a multi-org view based on IGI_RECOVERABLE_LINES_ALL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Invoice Identifier | |
ACCOUNTING_DATE | DATE | Accounting Date | ||
INVOICE_DATE | DATE | Invoice Date | ||
INV_CURRENCY_CODE | VARCHAR2 | (15) | Invoice Currency Code | |
ACCRUAL_SET_OF_BOOKS_ID | NUMBER | (15) | Set of Books Identifier of the Accrual Set of books | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
TAX_DISTRIBUTION_ID | NUMBER | (15) | Tax distribution identifier | |
TAX_CCID | NUMBER | (15) | Tax Code combination identifier | |
TAX_AMOUNT | NUMBER | Tax Amount Identifier | ||
ITEM_DISTRIBUTION_ID | NUMBER | (15) | Item Distribution Identifier | |
ITEM_CCID | NUMBER | (15) | Item Code combination identifier | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
CREATED_DATE | DATE | Standard Who Column | ||
ORG_ID | NUMBER | (15) | Organization identifier | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
JE_CREATED_FLAG | VARCHAR2 | (1) | Journal Created Flag |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, ACCOUNTING_DATE
, INVOICE_DATE
, INV_CURRENCY_CODE
, ACCRUAL_SET_OF_BOOKS_ID
, REQUEST_ID
, TAX_DISTRIBUTION_ID
, TAX_CCID
, TAX_AMOUNT
, ITEM_DISTRIBUTION_ID
, ITEM_CCID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATED_DATE
, ORG_ID
, LAST_UPDATE_LOGIN
, JE_CREATED_FLAG
FROM APPS.IGI_RECOVERABLE_LINES;
|
|
|