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_HOLD_DATA_FCV

Object Details

Object Name:	FIIBV_AP_HOLD_DATA_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FIIBV_AP_HOLD_DATA_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
GEOGRAPHY_FK	VARCHAR2	(126)		Foreign key to the geography dimension
HELD_BY	NUMBER	(15)	Yes	Employee who placed the hold on the invoice.
HOLD_BY_EMPLOYEE_FK	VARCHAR2	(85)		Foreign key to the employee dimension
HOLD_COUNT	NUMBER			Set to 1
HOLD_DATA_PK	VARCHAR2	(198)		Unique identifier
HOLD_DATE	DATE		Yes	Date the hold was placed
HOLD_DATE_FK	VARCHAR2	(76)		Foreign key to the hold date dimension
HOLD_FK	VARCHAR2	(25)		Foreign key to the hold dimension
HOLD_LOOKUP_CODE	VARCHAR2	(25)	Yes	Name of the hold code
HOLD_REASON	VARCHAR2	(240)		Reason for hold being placed
HOLD_RELEASE_COUNT	NUMBER			Set to 1 if this hold has been released. 0 otherwise.
HOLD_RELEASE_DAYS	NUMBER			Number of days from the hold date to the release days
INSTANCE	VARCHAR2	(30)		Instance identifier
INSTANCE_FK	VARCHAR2	(30)		Foreign key to the instance dimension
INV_AMT_B	NUMBER			Invoice amount in base currency.
INV_AMT_G	NUMBER			Invoice amount in global currency
INV_AMT_T	NUMBER			Invoice amount in transactional currency
INV_CURRENCY_FK	VARCHAR2	(15)		Foreign key to the invoice currency dimension
INV_FK	VARCHAR2	(112)		Foreign key to the invoice dimension
INV_NUM	VARCHAR2	(50)	Yes	Invoice number of the invoice on hold
INV_SOURCE	VARCHAR2	(25)		Invoice source of the invoice on hold
INV_SOURCE_FK	VARCHAR2	(25)		Foreign key to the invoice source dimension
INV_TYPE	VARCHAR2	(25)		Invoice type of the invoice on hold
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE1	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
RELEASE_FK	VARCHAR2	(25)		Foreign key to release dimension
RELEASE_LOOKUP_CODE	VARCHAR2	(25)		Name of release code
RELEASE_REASON	VARCHAR2	(240)		Reason for release being placed on invoice
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
SUPPLIER_SITE_ID	NUMBER	(15)		Supplier site identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Chart of accounts identifier
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type for a foreign currency invoice
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:HLD:_EDW	CHAR	(21)		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
TRANSACTION_DATE	DATE			Date 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
,      GEOGRAPHY_FK
,      HELD_BY
,      HOLD_BY_EMPLOYEE_FK
,      HOLD_COUNT
,      HOLD_DATA_PK
,      HOLD_DATE
,      HOLD_DATE_FK
,      HOLD_FK
,      HOLD_LOOKUP_CODE
,      HOLD_REASON
,      HOLD_RELEASE_COUNT
,      HOLD_RELEASE_DAYS
,      INSTANCE
,      INSTANCE_FK
,      INV_AMT_B
,      INV_AMT_G
,      INV_AMT_T
,      INV_CURRENCY_FK
,      INV_FK
,      INV_NUM
,      INV_SOURCE
,      INV_SOURCE_FK
,      INV_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_DATE1
,      ORG_FK
,      PAYMENT_TERM_FK
,      RELEASE_FK
,      RELEASE_LOOKUP_CODE
,      RELEASE_REASON
,      SIC_CODE_FK
,      DUNS_FK
,      SOB_FK
,      SUPPLIER_FK
,      SUPPLIER_SITE_ID
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      EXCHANGE_RATE_TYPE
,      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:HLD:_EDW
,      _DF:INV:_EDW
,      _DF:IVJ:_EDW
,      FROM_CURRENCY
,      TRANSACTION_DATE
,      GL_DATE
,      INVOICE_DATE
FROM APPS.FIIBV_AP_HOLD_DATA_FCV;

Dependencies

[top of page]

APPS.FIIBV_AP_HOLD_DATA_FCV references the following:

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

APPS.FIIBV_AP_HOLD_DATA_FCV is referenced by following:

APPS: FII_AP_HOLD_DATA_FCV