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_SCH_PAYMTS_FCV

Object Details

Object Name:	FII_AP_SCH_PAYMTS_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FII_AP_SCH_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)
PINVOICE_ID	NUMBER	(15)	Yes
INV_TYPE	VARCHAR2	(25)
PAY_NUM	NUMBER	(15)	Yes
CCID	NUMBER	(15)
COMPLETELY_PAID_PAYMENT_COUNT	NUMBER
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
DISC_AMT_TAKEN_B	NUMBER
DISC_AMT_TAKEN_G	NUMBER
DISC_AMT_TAKEN_T	NUMBER
DISC_DATE_FK	VARCHAR2	(76)
DUE_DATE	DATE
DUE_DATE_FK	VARCHAR2	(76)
EMPLOYEE_FK	VARCHAR2	(85)
INV_EXCHANGE_DATE	DATE
INV_EXCHANGE_RATE	NUMBER
INV_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
PAYMENT_EXCHANGE_RATE	NUMBER		Yes
PAYMENT_EXCHANGE_DATE	DATE
PAYMENT_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
FIRST_DISC_AVAILABLE_B	NUMBER
FIRST_DISC_AVAILABLE_G	NUMBER
FIRST_DISC_AVAILABLE_T	NUMBER
FIRST_DISC_DATE	DATE
GEOGRAPHY_FK	VARCHAR2	(126)
HOLD_FLAG	VARCHAR2	(1)
INSTANCE	VARCHAR2	(30)
INSTANCE_FK	VARCHAR2	(30)
INV_AMT_HAVING_DISC_B	NUMBER
INV_AMT_HAVING_DISC_G	NUMBER
INV_AMT_HAVING_DISC_T	NUMBER
INV_AMT_NOT_HAVING_DISC_B	NUMBER
INV_AMT_NOT_HAVING_DISC_G	NUMBER
INV_AMT_NOT_HAVING_DISC_T	NUMBER
INV_CURRENCY_FK	VARCHAR2	(15)
PAYMENT_CURRENCY_FK	VARCHAR2	(15)
INV_DATE_FK	VARCHAR2	(76)
INV_FK	VARCHAR2	(112)
INV_SOURCE_FK	VARCHAR2	(25)
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
ORG_FK	VARCHAR2	(71)
PARTIALLY_PAID_PAYMENT_COUNT	NUMBER
PAYMENT_AMT_B	NUMBER
PAYMENT_AMT_G	NUMBER
PAYMENT_AMT_T	NUMBER
PAYMENT_METHOD	VARCHAR2	(25)
PAYMENT_PRIORITY	NUMBER	(2)
PAYMENT_STATUS_FLAG	VARCHAR2	(25)
PAYMENT_TERM_FK	VARCHAR2	(74)
POTENTIAL_DISC_AMT_B	NUMBER
POTENTIAL_DISC_AMT_G	NUMBER
POTENTIAL_DISC_AMT_T	NUMBER
REMAINING_DISC_AMT_AT_RISK_B	NUMBER
REMAINING_DISC_AMT_AT_RISK_G	NUMBER
REMAINING_DISC_AMT_AT_RISK_T	NUMBER
REMAINING_INV_AMT_B	NUMBER
REMAINING_INV_AMT_G	NUMBER
REMAINING_INV_AMT_T	NUMBER
REMAINING_INV_AMT_AT_RISK_B	NUMBER
REMAINING_INV_AMT_AT_RISK_G	NUMBER
REMAINING_INV_AMT_AT_RISK_T	NUMBER
SCH_PAYMENT_PK	VARCHAR2	(153)
SECOND_DISC_AVAILABLE_B	NUMBER
SECOND_DISC_AVAILABLE_G	NUMBER
SECOND_DISC_AVAILABLE_T	NUMBER
SECOND_DISC_DATE	DATE
SIC_CODE_FK	VARCHAR2	(25)
DUNS_FK	CHAR	(6)
SOB_FK	VARCHAR2	(71)
SUPPLIER_FK	VARCHAR2	(126)
THIRD_DISC_AVAILABLE_B	NUMBER
THIRD_DISC_AVAILABLE_G	NUMBER
THIRD_DISC_AVAILABLE_T	NUMBER
THIRD_DISC_DATE	DATE
UNPAID_PAYMENT_COUNT	NUMBER
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes
GLOBAL_CURRENCY_RATE	NUMBER
INVOICE_NUM	VARCHAR2	(50)	Yes
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)
FROM_CURRENCY	VARCHAR2	(15)	Yes
GL_DATE	DATE		Yes
INVOICE_DATE	DATE

Query Text

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


SELECT SEQ_ID
,      PINVOICE_ID
,      INV_TYPE
,      PAY_NUM
,      CCID
,      COMPLETELY_PAID_PAYMENT_COUNT
,      CREATION_DATE
,      DISC_AMT_LOST_B
,      DISC_AMT_LOST_G
,      DISC_AMT_LOST_T
,      DISC_AMT_TAKEN_B
,      DISC_AMT_TAKEN_G
,      DISC_AMT_TAKEN_T
,      DISC_DATE_FK
,      DUE_DATE
,      DUE_DATE_FK
,      EMPLOYEE_FK
,      INV_EXCHANGE_DATE
,      INV_EXCHANGE_RATE
,      INV_EXCHANGE_RATE_TYPE
,      PAYMENT_EXCHANGE_RATE
,      PAYMENT_EXCHANGE_DATE
,      PAYMENT_EXCHANGE_RATE_TYPE
,      FIRST_DISC_AVAILABLE_B
,      FIRST_DISC_AVAILABLE_G
,      FIRST_DISC_AVAILABLE_T
,      FIRST_DISC_DATE
,      GEOGRAPHY_FK
,      HOLD_FLAG
,      INSTANCE
,      INSTANCE_FK
,      INV_AMT_HAVING_DISC_B
,      INV_AMT_HAVING_DISC_G
,      INV_AMT_HAVING_DISC_T
,      INV_AMT_NOT_HAVING_DISC_B
,      INV_AMT_NOT_HAVING_DISC_G
,      INV_AMT_NOT_HAVING_DISC_T
,      INV_CURRENCY_FK
,      PAYMENT_CURRENCY_FK
,      INV_DATE_FK
,      INV_FK
,      INV_SOURCE_FK
,      LAST_UPDATE_DATE
,      LAST_UPDATE_DATE1
,      LAST_UPDATE_DATE2
,      ORG_FK
,      PARTIALLY_PAID_PAYMENT_COUNT
,      PAYMENT_AMT_B
,      PAYMENT_AMT_G
,      PAYMENT_AMT_T
,      PAYMENT_METHOD
,      PAYMENT_PRIORITY
,      PAYMENT_STATUS_FLAG
,      PAYMENT_TERM_FK
,      POTENTIAL_DISC_AMT_B
,      POTENTIAL_DISC_AMT_G
,      POTENTIAL_DISC_AMT_T
,      REMAINING_DISC_AMT_AT_RISK_B
,      REMAINING_DISC_AMT_AT_RISK_G
,      REMAINING_DISC_AMT_AT_RISK_T
,      REMAINING_INV_AMT_B
,      REMAINING_INV_AMT_G
,      REMAINING_INV_AMT_T
,      REMAINING_INV_AMT_AT_RISK_B
,      REMAINING_INV_AMT_AT_RISK_G
,      REMAINING_INV_AMT_AT_RISK_T
,      SCH_PAYMENT_PK
,      SECOND_DISC_AVAILABLE_B
,      SECOND_DISC_AVAILABLE_G
,      SECOND_DISC_AVAILABLE_T
,      SECOND_DISC_DATE
,      SIC_CODE_FK
,      DUNS_FK
,      SOB_FK
,      SUPPLIER_FK
,      THIRD_DISC_AVAILABLE_B
,      THIRD_DISC_AVAILABLE_G
,      THIRD_DISC_AVAILABLE_T
,      THIRD_DISC_DATE
,      UNPAID_PAYMENT_COUNT
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      GLOBAL_CURRENCY_RATE
,      INVOICE_NUM
,      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
,      FROM_CURRENCY
,      GL_DATE
,      INVOICE_DATE
FROM APPS.FII_AP_SCH_PAYMTS_FCV;

Dependencies

[top of page]

APPS.FII_AP_SCH_PAYMTS_FCV references the following:

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

APPS.FII_AP_SCH_PAYMTS_FCV is referenced by following:

APPS: FII_AP_SCH_PAYMTS_F_C - show dependent code