DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.IGI_AP_INVOICE_LINES_V

Object Details
Object Name: IGI_AP_INVOICE_LINES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.IGI_AP_INVOICE_LINES_V references the following:

SchemaAPPS
SynonymAP_INVOICE_LINES_ALL
SynonymIGI_INVOICE_LINES

APPS.IGI_AP_INVOICE_LINES_V is not referenced by any database object