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.IGI_MPP_EXP_RECOGNITION

Object Details

Object Name:	IGI_MPP_EXP_RECOGNITION
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGI.IGI_MPP_EXP_RECOGNITION
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code for invoice
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes	Invoice distribution line number
VENDOR_NAME	VARCHAR2	(360)		Supplier name
VENDOR_SITE_CODE	VARCHAR2	(15)		Code for supplier site
INVOICE_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Type of invoice
ACCOUNTING_DATE	DATE		Yes	Date distribution line first eneterd
AMOUNT	NUMBER			Distribution amount
ENTERED_DR	NUMBER			Debit account for transactional currency
ENTERED_CR	NUMBER			Credit account for transactional currency
ACCOUNTED_DR	NUMBER			Debit account for functional currency
ACCOUNTED_CR	NUMBER			Credit account for functional currency
CODE_COMBINATION_ID	NUMBER			Accounting code
PERIOD_NAME	VARCHAR2	(15)		Accounting period name
BATCH_ID	NUMBER			Invoice batch identifier
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Chart of accounts identifier
INVOICE_NUM	VARCHAR2	(50)	Yes	Invoice number
EFFECTIVE_PERIOD_NUM	NUMBER	(15)	Yes	Denormalized period number (period_year*10000 + period_num)
START_DATE	DATE		Yes	Start date
END_DATE	DATE		Yes	End date
MPP_DIST_LINE_NUMBER	VARCHAR2	(240)		Multi Period Posting distribution line number
EXPENSE_RECOGNIZED_FLAG	VARCHAR2	(1)		Indicates whether expense recognition routine has marked this entry
SUBLEDGER_ENTRY_ID	NUMBER		Yes	Sequence number

Query Text

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


SELECT INVOICE_CURRENCY_CODE
,      DISTRIBUTION_LINE_NUMBER
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      INVOICE_TYPE_LOOKUP_CODE
,      ACCOUNTING_DATE
,      AMOUNT
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      CODE_COMBINATION_ID
,      PERIOD_NAME
,      BATCH_ID
,      INVOICE_ID
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      INVOICE_NUM
,      EFFECTIVE_PERIOD_NUM
,      START_DATE
,      END_DATE
,      MPP_DIST_LINE_NUMBER
,      EXPENSE_RECOGNIZED_FLAG
,      SUBLEDGER_ENTRY_ID
FROM APPS.IGI_MPP_EXP_RECOGNITION;

Dependencies

[top of page]

APPS.IGI_MPP_EXP_RECOGNITION references the following:

APPS: AP_INVOICES_PKG - show dependent code; AP_INVOICES_UTILITY_PKG - show dependent code; AP_INVOICES_V; AP_INVOICE_DISTRIBUTIONS_PKG - show dependent code; AP_INVOICE_DISTRIBUTIONS_V; AP_PREPAY_UTILS_PKG - show dependent code; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; FND_USER_AP_PKG - show dependent code; GL_PERIOD_STATUSES; GL_SETS_OF_BOOKS; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; IGI_MPP_SUBLEDGER; PA_TASK_UTILS - show dependent code; PA_UTILS4 - show dependent code

APPS.IGI_MPP_EXP_RECOGNITION is not referenced by any database object