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

Object Details

Object Name:	FII_AP_HOLD_DATA_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FII_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)
HOLD_DATA_PK	VARCHAR2	(198)
INSTANCE_FK	VARCHAR2	(30)
DUNS_FK	CHAR	(6)
GEOGRAPHY_FK	VARCHAR2	(126)
GL_ACCT1_FK	VARCHAR2	(3775)
GL_ACCT2_FK	VARCHAR2	(3775)
GL_ACCT3_FK	VARCHAR2	(3775)
GL_ACCT4_FK	VARCHAR2	(3775)
GL_ACCT5_FK	VARCHAR2	(3775)
GL_ACCT6_FK	VARCHAR2	(3775)
GL_ACCT7_FK	VARCHAR2	(3775)
GL_ACCT8_FK	VARCHAR2	(3775)
GL_ACCT9_FK	VARCHAR2	(3775)
GL_ACCT10_FK	VARCHAR2	(3775)
HOLD_BY_EMPLOYEE_FK	VARCHAR2	(85)
HOLD_DATE_FK	VARCHAR2	(76)
HOLD_FK	VARCHAR2	(25)
INV_CURRENCY_FK	VARCHAR2	(15)
INV_FK	VARCHAR2	(112)
INV_SOURCE_FK	VARCHAR2	(25)
ORG_FK	VARCHAR2	(71)
PAYMENT_TERM_FK	VARCHAR2	(74)
RELEASE_FK	VARCHAR2	(25)
SIC_CODE_FK	VARCHAR2	(25)
SUPPLIER_FK	VARCHAR2	(126)
SOB_FK	VARCHAR2	(71)
HELD_BY	NUMBER	(15)	Yes
HOLD_COUNT	NUMBER
HOLD_DATE	DATE		Yes
HOLD_LOOKUP_CODE	VARCHAR2	(25)	Yes
HOLD_REASON	VARCHAR2	(240)
HOLD_RELEASE_COUNT	NUMBER
HOLD_RELEASE_DAYS	NUMBER
INSTANCE	VARCHAR2	(30)
INV_AMT_B	NUMBER
INV_AMT_G	NUMBER
INV_AMT_T	NUMBER
INV_NUM	VARCHAR2	(50)	Yes
INV_SOURCE	VARCHAR2	(25)
INV_TYPE	VARCHAR2	(25)
RELEASE_LOOKUP_CODE	VARCHAR2	(25)
RELEASE_REASON	VARCHAR2	(240)
SUPPLIER_SITE_ID	NUMBER	(15)
CCID	NUMBER	(15)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes
GLOBAL_CURRENCY_RATE	NUMBER
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
CREATION_DATE	DATE			Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_DATE1	DATE		Yes
USER_MEASURE1	NUMBER
USER_MEASURE2	NUMBER
USER_MEASURE3	NUMBER
USER_MEASURE4	NUMBER
USER_MEASURE5	NUMBER
USER_ATTRIBUTE1	VARCHAR2	(0)
USER_ATTRIBUTE2	VARCHAR2	(0)
USER_ATTRIBUTE3	VARCHAR2	(0)
USER_ATTRIBUTE4	VARCHAR2	(0)
USER_ATTRIBUTE5	VARCHAR2	(0)
USER_ATTRIBUTE6	VARCHAR2	(0)
USER_ATTRIBUTE7	VARCHAR2	(0)
USER_ATTRIBUTE8	VARCHAR2	(0)
USER_ATTRIBUTE9	VARCHAR2	(0)
USER_ATTRIBUTE10	VARCHAR2	(0)
USER_FK1	VARCHAR2	(0)
USER_FK2	VARCHAR2	(0)
USER_FK3	VARCHAR2	(0)
USER_FK4	VARCHAR2	(0)
USER_FK5	VARCHAR2	(0)
FROM_CURRENCY	VARCHAR2	(15)	Yes
TRANSACTION_DATE	DATE
GL_DATE	DATE		Yes
INVOICE_DATE	DATE

Query Text

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


SELECT SEQ_ID
,      HOLD_DATA_PK
,      INSTANCE_FK
,      DUNS_FK
,      GEOGRAPHY_FK
,      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
,      HOLD_BY_EMPLOYEE_FK
,      HOLD_DATE_FK
,      HOLD_FK
,      INV_CURRENCY_FK
,      INV_FK
,      INV_SOURCE_FK
,      ORG_FK
,      PAYMENT_TERM_FK
,      RELEASE_FK
,      SIC_CODE_FK
,      SUPPLIER_FK
,      SOB_FK
,      HELD_BY
,      HOLD_COUNT
,      HOLD_DATE
,      HOLD_LOOKUP_CODE
,      HOLD_REASON
,      HOLD_RELEASE_COUNT
,      HOLD_RELEASE_DAYS
,      INSTANCE
,      INV_AMT_B
,      INV_AMT_G
,      INV_AMT_T
,      INV_NUM
,      INV_SOURCE
,      INV_TYPE
,      RELEASE_LOOKUP_CODE
,      RELEASE_REASON
,      SUPPLIER_SITE_ID
,      CCID
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      GLOBAL_CURRENCY_RATE
,      EXCHANGE_RATE_TYPE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_DATE1
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      FROM_CURRENCY
,      TRANSACTION_DATE
,      GL_DATE
,      INVOICE_DATE
FROM APPS.FII_AP_HOLD_DATA_FCV;

Dependencies

[top of page]

APPS.FII_AP_HOLD_DATA_FCV references the following:

APPS: EDW_CURRENCY - show dependent code; FIIBV_AP_HOLD_DATA_FCV; FII_FLEX_MAPPING - show dependent code

APPS.FII_AP_HOLD_DATA_FCV is referenced by following:

APPS: FII_AP_HOLD_DATA_F_C - show dependent code