[Home] [Help] [Dependency Information]
Object Name: | IGI_AP_INVOICE_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
View created for R12 Uptake of SIA. MOAC Impact
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Yes | Invoice ID |
LINE_NUMBER | NUMBER | Yes | Invoice line number | |
LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | Line type lookup code |
LINE_SOURCE | VARCHAR2 | (30) | Line source | |
ORG_ID | NUMBER | (15) | Organization ID | |
DEFAULT_DIST_CCID | NUMBER | (15) | Default distribution code combination ID | |
ACCOUNTING_DATE | DATE | Yes | Accounting date | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Ledger ID |
AMOUNT | NUMBER | Yes | Amount | |
DISCARDED_FLAG | VARCHAR2 | (1) | Discarded flag | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_DATE | DATE | Yes | Standard who column | |
PERIOD_NAME | VARCHAR2 | (15) | Period name | |
BASE_AMOUNT | NUMBER | Base amount | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
IGI_SAP_FLAG | VARCHAR2 | (1) | Public Sector Financials (International) secondary approval flag | |
IGI_ROWID | ROWID | (10) | Row ID | |
LINES_ROWID | ROWID | (10) | Invoice lines row ID |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, LINE_NUMBER
, LINE_TYPE_LOOKUP_CODE
, LINE_SOURCE
, ORG_ID
, DEFAULT_DIST_CCID
, ACCOUNTING_DATE
, SET_OF_BOOKS_ID
, AMOUNT
, DISCARDED_FLAG
, LAST_UPDATED_BY
, LAST_UPDATED_DATE
, PERIOD_NAME
, BASE_AMOUNT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, IGI_SAP_FLAG
, IGI_ROWID
, LINES_ROWID
FROM APPS.IGI_AP_INVOICE_LINES_V;
APPS.IGI_AP_INVOICE_LINES_V is not referenced by any database object
|
|
|