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_INV_PAYMTS_FCV

Object Details

Object Name:	FII_AP_INV_PAYMTS_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FII_AP_INV_PAYMTS_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)
ACCOUNTING_DATE	DATE		Yes
ACCRUAL_POSTED_FLAG	VARCHAR2	(1)
ASSETS_ADDITION_FLAG	VARCHAR2	(1)
BANK_ACCOUNT_ID	NUMBER	(15)
BASE_CURRENCY_CODE	VARCHAR2	(15)	Yes
CASH_JE_BATCH_ID	NUMBER	(15)
CASH_POSTED_FLAG	VARCHAR2	(1)
CCID	NUMBER	(15)
CHECK_DATE	DATE		Yes
CREATION_DATE	DATE			Standard who column - date when this row was created.
DISC_AMT_LOST_B	NUMBER
DISC_AMT_LOST_G	NUMBER
DISC_AMT_LOST_T	NUMBER
EARLY_DISC_PAYMENT_AMT_B	NUMBER
EARLY_DISC_PAYMENT_AMT_G	NUMBER
EARLY_DISC_PAYMENT_AMT_T	NUMBER
EARLY_DISC_PAYMENT_DAYS	NUMBER
EARLY_DISC_PAYMENT_COUNT	NUMBER
EARLY_NET_PAYMENT_AMT_B	NUMBER
EARLY_NET_PAYMENT_AMT_G	NUMBER
EARLY_NET_PAYMENT_AMT_T	NUMBER
EARLY_NET_PAYMENT_COUNT	NUMBER
EARLY_NET_PAYMENT_DAYS	NUMBER
EMPLOYEE_FK	VARCHAR2	(85)
FUTURE_PAY_POSTED_FLAG	VARCHAR2	(1)
GEOGRAPHY_FK	VARCHAR2	(126)
INSTANCE	VARCHAR2	(30)
INSTANCE_FK	VARCHAR2	(30)
INVOICE_DATE	DATE
INV_CURRENCY_CODE	VARCHAR2	(15)	Yes
INV_EXCHANGE_DATE	DATE
INV_EXCHANGE_RATE	NUMBER
INV_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
INV_FK	VARCHAR2	(112)
INV_NUM	VARCHAR2	(50)	Yes
INV_PAYMENT_PK	VARCHAR2	(112)
INV_PAYMENT_STATUS_FLAG	VARCHAR2	(1)
INV_PAYMENT_TYPE	VARCHAR2	(25)
INV_SOURCE	VARCHAR2	(25)
INV_SOURCE_FK	VARCHAR2	(25)
INV_TYPE	VARCHAR2	(25)
JE_BATCH_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_DATE1	DATE		Yes
LAST_UPDATE_DATE2	DATE		Yes
LATE_DISC_DAYS	NUMBER
LATE_DISC_PAYMENT_AMT_B	NUMBER
LATE_DISC_PAYMENT_AMT_G	NUMBER
LATE_DISC_PAYMENT_AMT_T	NUMBER
LATE_DISC_PAYMENT_COUNT	NUMBER
LATE_NET_PAYMENT_AMT_B	NUMBER
LATE_NET_PAYMENT_AMT_G	NUMBER
LATE_NET_PAYMENT_AMT_T	NUMBER
LATE_NET_PAYMENT_COUNT	NUMBER
LATE_NET_PAYMENT_DAYS	NUMBER
ORG_FK	VARCHAR2	(71)
PAYMENT_AMT_B	NUMBER
PAYMENT_AMT_G	NUMBER
PAYMENT_AMT_T	NUMBER		Yes
PAYMENT_COUNT	NUMBER
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)	Yes
PAYMENT_CURRENCY_FK	VARCHAR2	(15)
PAYMENT_DATE_FK	VARCHAR2	(76)
DISC_AMT_TAKEN_B	NUMBER
DISC_AMT_TAKEN_G	NUMBER
DISC_AMT_TAKEN_T	NUMBER
PAYMENT_EXCHANGE_DATE	DATE
PAYMENT_EXCHANGE_RATE	NUMBER
PAYMENT_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
PAYMENT_FK	VARCHAR2	(112)
PAYMENT_TERM_FK	VARCHAR2	(74)
POSTED_FLAG	VARCHAR2	(1)	Yes
SIC_CODE_FK	VARCHAR2	(25)
DUNS_FK	CHAR	(6)
SOB_FK	VARCHAR2	(71)
SUPPLIER_FK	VARCHAR2	(126)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes
GLOBAL_CURRENCY_RATE	NUMBER
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)
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)
CHECK_AMT_B	NUMBER
CHECK_AMT_T	NUMBER		Yes
CHECK_AMT_G	NUMBER
CHECK_NUMBER	NUMBER	(15)	Yes

Query Text

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


SELECT SEQ_ID
,      ACCOUNTING_DATE
,      ACCRUAL_POSTED_FLAG
,      ASSETS_ADDITION_FLAG
,      BANK_ACCOUNT_ID
,      BASE_CURRENCY_CODE
,      CASH_JE_BATCH_ID
,      CASH_POSTED_FLAG
,      CCID
,      CHECK_DATE
,      CREATION_DATE
,      DISC_AMT_LOST_B
,      DISC_AMT_LOST_G
,      DISC_AMT_LOST_T
,      EARLY_DISC_PAYMENT_AMT_B
,      EARLY_DISC_PAYMENT_AMT_G
,      EARLY_DISC_PAYMENT_AMT_T
,      EARLY_DISC_PAYMENT_DAYS
,      EARLY_DISC_PAYMENT_COUNT
,      EARLY_NET_PAYMENT_AMT_B
,      EARLY_NET_PAYMENT_AMT_G
,      EARLY_NET_PAYMENT_AMT_T
,      EARLY_NET_PAYMENT_COUNT
,      EARLY_NET_PAYMENT_DAYS
,      EMPLOYEE_FK
,      FUTURE_PAY_POSTED_FLAG
,      GEOGRAPHY_FK
,      INSTANCE
,      INSTANCE_FK
,      INVOICE_DATE
,      INV_CURRENCY_CODE
,      INV_EXCHANGE_DATE
,      INV_EXCHANGE_RATE
,      INV_EXCHANGE_RATE_TYPE
,      INV_FK
,      INV_NUM
,      INV_PAYMENT_PK
,      INV_PAYMENT_STATUS_FLAG
,      INV_PAYMENT_TYPE
,      INV_SOURCE
,      INV_SOURCE_FK
,      INV_TYPE
,      JE_BATCH_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATE_DATE1
,      LAST_UPDATE_DATE2
,      LATE_DISC_DAYS
,      LATE_DISC_PAYMENT_AMT_B
,      LATE_DISC_PAYMENT_AMT_G
,      LATE_DISC_PAYMENT_AMT_T
,      LATE_DISC_PAYMENT_COUNT
,      LATE_NET_PAYMENT_AMT_B
,      LATE_NET_PAYMENT_AMT_G
,      LATE_NET_PAYMENT_AMT_T
,      LATE_NET_PAYMENT_COUNT
,      LATE_NET_PAYMENT_DAYS
,      ORG_FK
,      PAYMENT_AMT_B
,      PAYMENT_AMT_G
,      PAYMENT_AMT_T
,      PAYMENT_COUNT
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_CURRENCY_FK
,      PAYMENT_DATE_FK
,      DISC_AMT_TAKEN_B
,      DISC_AMT_TAKEN_G
,      DISC_AMT_TAKEN_T
,      PAYMENT_EXCHANGE_DATE
,      PAYMENT_EXCHANGE_RATE
,      PAYMENT_EXCHANGE_RATE_TYPE
,      PAYMENT_FK
,      PAYMENT_TERM_FK
,      POSTED_FLAG
,      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
,      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
,      CHECK_AMT_B
,      CHECK_AMT_T
,      CHECK_AMT_G
,      CHECK_NUMBER
FROM APPS.FII_AP_INV_PAYMTS_FCV;

Dependencies

[top of page]

APPS.FII_AP_INV_PAYMTS_FCV references the following:

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

APPS.FII_AP_INV_PAYMTS_FCV is referenced by following:

APPS: FII_AP_INV_PAYMTS_F_C - show dependent code