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

Object Details

Object Name:	FIIBV_AP_INV_ON_HOLD_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FIIBV_AP_INV_ON_HOLD_FCV
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQ_ID	NUMBER	(15)		This column is for internal use only
CCID	NUMBER	(15)		Invoice accounting flexfield identifier for accounts payable liability account
CREATION_DATE	DATE			Standard Who column
DELETION_DATE	VARCHAR2	(0)		Deletion date of the record
EMPLOYEE_FK	VARCHAR2	(85)		Foreign key to the employee dimension
EXCHANGE_DATE	DATE			Date exchange rate is effective
EXCHANGE_RATE	NUMBER			Exchange rate for a foreign currency invoice.
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type
GEOGRAPHY_FK	VARCHAR2	(126)		Foreign key to the geography dimension
INSTANCE	VARCHAR2	(30)		Instance identifier
INSTANCE_FK	VARCHAR2	(30)		Foreign key to the instance dimension
INV_AMT_ON_HOLD_B	NUMBER			Invoice amount in functional currency of invoice on hold
INV_AMT_ON_HOLD_G	NUMBER			Invoice amount in global currency of invoice being held
INV_AMT_ON_HOLD_T	NUMBER			Invoice amount in transaction currency of invoice being held
INV_CURRENCY_FK	VARCHAR2	(15)		Foreign key to the invoice currency dimension
INV_DATE_FK	VARCHAR2	(76)		Foreign key to the invoice date dimension
INV_FK	VARCHAR2	(112)		Foreign key to the invoice type dimension
INV_NUM	VARCHAR2	(50)	Yes	Invoice number of invoice being held
INV_ON_HOLD_COUNT	NUMBER			Set to 1
INV_ON_HOLD_PK	VARCHAR2	(112)		Unique identifier
INV_SOURCE_FK	VARCHAR2	(25)		Foreign key to the invoice source dimension
INV_TYPE	VARCHAR2	(25)		Type of invoice placed on hold.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
ORG_FK	VARCHAR2	(71)		Foreign key to the organization dimension
PAYMENT_TERM_FK	VARCHAR2	(74)		Foreign key to the payment term dimension
SIC_CODE_FK	VARCHAR2	(25)		Foreign key to the standard industry code,SIC, dimension
DUNS_FK	CHAR	(6)		Foreign key to the data universal numbering system,DUNS, dimension
SOB_FK	VARCHAR2	(71)		Foreign key to the set of books dimension
SUPPLIER_FK	VARCHAR2	(126)		Foreign key to the supplier dimension
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Chart of accounts identifier
GLOBAL_CURRENCY_RATE	NUMBER			Exchange rate for a foreign currency invoice
GL_ACCT1_FK	CHAR	(6)		Foreign key to the Accounting Flexfield dimension
GL_ACCT2_FK	CHAR	(6)		Foreign key to the Accounting Flexfield dimension
GL_ACCT3_FK	CHAR	(6)		Foreign key to the Accounting Flexfield dimension
GL_ACCT4_FK	CHAR	(6)		Foreign key to the Accounting Flexfield dimension
GL_ACCT5_FK	CHAR	(6)		Foreign key to the Accounting Flexfield dimension
GL_ACCT6_FK	CHAR	(6)		Foreign key to the Accounting Flexfield dimension
GL_ACCT7_FK	CHAR	(6)		Foreign key to the Accounting Flexfield dimension
GL_ACCT8_FK	CHAR	(6)		Foreign key to the Accounting Flexfield dimension
GL_ACCT9_FK	CHAR	(6)		Foreign key to the Accounting Flexfield dimension
GL_ACCT10_FK	CHAR	(6)		Foreign key to the Accounting Flexfield dimension
_KF:GL_ACCT_NUM:ACCT:_EDW	CHAR	(17)		This column is for internal use only
_DF:INV:_EDW	CHAR	(24)		This column is for internal use only
_DF:IVJ:_EDW	CHAR	(24)		This column is for internal use only
FROM_CURRENCY	VARCHAR2	(15)	Yes	Currency used by edw_currency.get_rate api to calculate GLOBAL_CURRENCY_RATE
GL_DATE	DATE		Yes
INVOICE_DATE	DATE

Query Text

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


SELECT SEQ_ID
,      CCID
,      CREATION_DATE
,      DELETION_DATE
,      EMPLOYEE_FK
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      GEOGRAPHY_FK
,      INSTANCE
,      INSTANCE_FK
,      INV_AMT_ON_HOLD_B
,      INV_AMT_ON_HOLD_G
,      INV_AMT_ON_HOLD_T
,      INV_CURRENCY_FK
,      INV_DATE_FK
,      INV_FK
,      INV_NUM
,      INV_ON_HOLD_COUNT
,      INV_ON_HOLD_PK
,      INV_SOURCE_FK
,      INV_TYPE
,      LAST_UPDATE_DATE
,      ORG_FK
,      PAYMENT_TERM_FK
,      SIC_CODE_FK
,      DUNS_FK
,      SOB_FK
,      SUPPLIER_FK
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      GLOBAL_CURRENCY_RATE
,      GL_ACCT1_FK
,      GL_ACCT2_FK
,      GL_ACCT3_FK
,      GL_ACCT4_FK
,      GL_ACCT5_FK
,      GL_ACCT6_FK
,      GL_ACCT7_FK
,      GL_ACCT8_FK
,      GL_ACCT9_FK
,      GL_ACCT10_FK
,      _KF:GL_ACCT_NUM:ACCT:_EDW
,      _DF:INV:_EDW
,      _DF:IVJ:_EDW
,      FROM_CURRENCY
,      GL_DATE
,      INVOICE_DATE
FROM APPS.FIIBV_AP_INV_ON_HOLD_FCV;

Dependencies

[top of page]

APPS.FIIBV_AP_INV_ON_HOLD_FCV references the following:

APPS: AP_HOLDS_ALL; AP_INVOICES_ALL; AP_PAYMENT_SCHEDULES_ALL; EDW_CURRENCY - show dependent code; EDW_LOCAL_INSTANCE; EDW_LOCAL_SYSTEM_PARAMETERS; FII_AP_TMP_INVH_PK; FND_USER; GL_CODE_COMBINATIONS; GL_SETS_OF_BOOKS; PO_VENDORS

APPS.FIIBV_AP_INV_ON_HOLD_FCV is referenced by following:

APPS: FII_AP_INV_ON_HOLD_FCV