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]

TABLE: APPS.FII_AP_INV_PAYMENTS_MV

Object Details

Object Name:	FII_AP_INV_PAYMENTS_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.FII_AP_INV_PAYMENTS_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_FII_AP_INV_PAYMENT	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("CHECK_ID") SYS_OP_MAP_NONNULL("INVOICE_ID") SYS_OP_MAP_NONNULL("PAYMENT_NUM") SYS_OP_MAP_NONNULL("PAYMENT_METHOD") SYS_OP_MAP_NONNULL("INV_PYMT_FLAG") SYS_OP_MAP_NONNULL("ORG_ID") SYS_OP_MAP_NONNULL("SUPPLIER_ID") SYS_OP_MAP_NONNULL("BASE_CURRENCY_CODE") SYS_OP_MAP_NONNULL("INVOICE_CURRENCY_CODE") SYS_OP_MAP_NONNULL("CHECK_DATE") SYS_OP_MAP_NONNULL("ENT_YEAR_ID") SYS_OP_MAP_NONNULL("ENT_QTR_ID") SYS_OP_MAP_NONNULL("ENT_PERIOD_ID") SYS_OP_MAP_NONNULL("WEEK_ID") SYS_OP_MAP_NONNULL("REPORT_DATE_JULIAN") SYS_OP_MAP_NONNULL("GID")
FII_AP_INV_PAYMENTS_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_TYPE_ID TIME_ID ORG_ID
FII_AP_INV_PAYMENTS_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_TYPE_ID TIME_ID SUPPLIER_ID ORG_ID

Columns

Name	Datatype	Length
TIME_ID	NUMBER
PERIOD_TYPE_ID	NUMBER
ENT_YEAR_ID	NUMBER
ENT_QTR_ID	NUMBER
ENT_PERIOD_ID	NUMBER
WEEK_ID	NUMBER
REPORT_DATE_JULIAN	NUMBER
CHECK_ID	NUMBER	(15)
INVOICE_ID	NUMBER	(15)
PAYMENT_NUM	NUMBER	(15)
PAYMENT_METHOD	VARCHAR2	(1)
INV_PYMT_FLAG	VARCHAR2	(1)
ORG_ID	NUMBER	(15)
SUPPLIER_ID	NUMBER	(15)
BASE_CURRENCY_CODE	VARCHAR2	(25)
INVOICE_CURRENCY_CODE	VARCHAR2	(25)
CHECK_DATE	DATE
NO_DAYS_LATE	NUMBER
PAYMENT_AMOUNT	NUMBER
PAYMENT_AMOUNT_B	NUMBER
PRIM_PAYMENT_AMOUNT	NUMBER
SEC_PAYMENT_AMOUNT	NUMBER
DISCOUNT_TAKEN	NUMBER
DISCOUNT_TAKEN_B	NUMBER
PRIM_DISCOUNT_TAKEN	NUMBER
SEC_DISCOUNT_TAKEN	NUMBER
OT_PAYMENT_AMT	NUMBER
OT_PAYMENT_AMT_B	NUMBER
PRIM_OT_PAYMENT_AMT	NUMBER
SEC_OT_PAYMENT_AMT	NUMBER
LATE_PAYMENT_AMT	NUMBER
LATE_PAYMENT_AMT_B	NUMBER
PRIM_LATE_PAYMENT_AMT	NUMBER
SEC_LATE_PAYMENT_AMT	NUMBER
NO_DAYS_LATE_PP	NUMBER
PAYMENT_AMOUNT_PP	NUMBER
PAYMENT_AMOUNT_B_PP	NUMBER
PRIM_PAYMENT_AMOUNT_PP	NUMBER
SEC_PAYMENT_AMOUNT_PP	NUMBER
OT_PAYMENT_AMT_PP	NUMBER
OT_PAYMENT_AMT_B_PP	NUMBER
PRIM_OT_PAYMENT_AMT_PP	NUMBER
SEC_OT_PAYMENT_AMT_PP	NUMBER
LATE_PAYMENT_AMT_PP	NUMBER
LATE_PAYMENT_AMT_B_PP	NUMBER
PRIM_LATE_PAYMENT_AMT_PP	NUMBER
SEC_LATE_PAYMENT_AMT_PP	NUMBER
NO_DAYS_LATE_PMT	NUMBER
PAYMENT_AMOUNT_PMT	NUMBER
PAYMENT_AMOUNT_B_PMT	NUMBER
PRIM_PAYMENT_AMOUNT_PMT	NUMBER
SEC_PAYMENT_AMOUNT_PMT	NUMBER
OT_PAYMENT_AMT_PMT	NUMBER
OT_PAYMENT_AMT_B_PMT	NUMBER
PRIM_OT_PAYMENT_AMT_PMT	NUMBER
SEC_OT_PAYMENT_AMT_PMT	NUMBER
LATE_PAYMENT_AMT_PMT	NUMBER
LATE_PAYMENT_AMT_B_PMT	NUMBER
PRIM_LATE_PAYMENT_AMT_PMT	NUMBER
SEC_LATE_PAYMENT_AMT_PMT	NUMBER
GID	NUMBER
NO_DAYS_LATE_CT	NUMBER
PAYMENT_AMOUNT_CT	NUMBER
PAYMENT_AMOUNT_B_CT	NUMBER
PRIM_PAYMENT_AMOUNT_CT	NUMBER
SEC_PAYMENT_AMOUNT_CT	NUMBER
DISCOUNT_TAKEN_CT	NUMBER
DISCOUNT_TAKEN_B_CT	NUMBER
PRIM_DISCOUNT_TAKEN_CT	NUMBER
SEC_DISCOUNT_TAKEN_CT	NUMBER
OT_PAYMENT_AMT_CT	NUMBER
OT_PAYMENT_AMT_B_CT	NUMBER
PRIM_OT_PAYMENT_AMT_CT	NUMBER
SEC_OT_PAYMENT_AMT_CT	NUMBER
LATE_PAYMENT_AMT_CT	NUMBER
LATE_PAYMENT_AMT_B_CT	NUMBER
PRIM_LATE_PAYMENT_AMT_CT	NUMBER
SEC_LATE_PAYMENT_AMT_CT	NUMBER
NO_DAYS_LATE_PP_CT	NUMBER
PAYMENT_AMOUNT_PP_CT	NUMBER
PAYMENT_AMOUNT_PP_B_CT	NUMBER
PRIM_PAYMENT_AMOUNT_PP_CT	NUMBER
SEC_PAYMENT_AMOUNT_PP_CT	NUMBER
OT_PAYMENT_AMT_PP_CT	NUMBER
OT_PAYMENT_AMT_B_PP_CT	NUMBER
PRIM_OT_PAYMENT_AMT_PP_CT	NUMBER
SEC_OT_PAYMENT_AMT_PP_CT	NUMBER
LATE_PAYMENT_AMT_PP_CT	NUMBER
LATE_PAYMENT_AMT_B_PP_CT	NUMBER
PRIM_LATE_PAYMENT_AMT_PP_CT	NUMBER
SEC_LATE_PAYMENT_AMT_PP_CT	NUMBER
NO_DAYS_LATE_PMT_CT	NUMBER
PAYMENT_AMOUNT_PMT_CT	NUMBER
PAYMENT_AMOUNT_B_PMT_CT	NUMBER
PRIM_PAYMENT_AMOUNT_PMT_CT	NUMBER
SEC_PAYMENT_AMOUNT_PMT_CT	NUMBER
OT_PAYMENT_AMT_PMT_CT	NUMBER
OT_PAYMENT_AMT_B_PMT_CT	NUMBER
PRIM_OT_PAYMENT_AMT_PMT_CT	NUMBER
SEC_OT_PAYMENT_AMT_PMT_CT	NUMBER
LATE_PAYMENT_AMT_PMT_CT	NUMBER
LATE_PAYMENT_AMT_B_PMT_CT	NUMBER
PRIM_LATE_PAYMENT_AMT_PMT_CT	NUMBER
SEC_LATE_PAYMENT_AMT_PMT_CT	NUMBER
CT	NUMBER

Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      REPORT_DATE_JULIAN
,      CHECK_ID
,      INVOICE_ID
,      PAYMENT_NUM
,      PAYMENT_METHOD
,      INV_PYMT_FLAG
,      ORG_ID
,      SUPPLIER_ID
,      BASE_CURRENCY_CODE
,      INVOICE_CURRENCY_CODE
,      CHECK_DATE
,      NO_DAYS_LATE
,      PAYMENT_AMOUNT
,      PAYMENT_AMOUNT_B
,      PRIM_PAYMENT_AMOUNT
,      SEC_PAYMENT_AMOUNT
,      DISCOUNT_TAKEN
,      DISCOUNT_TAKEN_B
,      PRIM_DISCOUNT_TAKEN
,      SEC_DISCOUNT_TAKEN
,      OT_PAYMENT_AMT
,      OT_PAYMENT_AMT_B
,      PRIM_OT_PAYMENT_AMT
,      SEC_OT_PAYMENT_AMT
,      LATE_PAYMENT_AMT
,      LATE_PAYMENT_AMT_B
,      PRIM_LATE_PAYMENT_AMT
,      SEC_LATE_PAYMENT_AMT
,      NO_DAYS_LATE_PP
,      PAYMENT_AMOUNT_PP
,      PAYMENT_AMOUNT_B_PP
,      PRIM_PAYMENT_AMOUNT_PP
,      SEC_PAYMENT_AMOUNT_PP
,      OT_PAYMENT_AMT_PP
,      OT_PAYMENT_AMT_B_PP
,      PRIM_OT_PAYMENT_AMT_PP
,      SEC_OT_PAYMENT_AMT_PP
,      LATE_PAYMENT_AMT_PP
,      LATE_PAYMENT_AMT_B_PP
,      PRIM_LATE_PAYMENT_AMT_PP
,      SEC_LATE_PAYMENT_AMT_PP
,      NO_DAYS_LATE_PMT
,      PAYMENT_AMOUNT_PMT
,      PAYMENT_AMOUNT_B_PMT
,      PRIM_PAYMENT_AMOUNT_PMT
,      SEC_PAYMENT_AMOUNT_PMT
,      OT_PAYMENT_AMT_PMT
,      OT_PAYMENT_AMT_B_PMT
,      PRIM_OT_PAYMENT_AMT_PMT
,      SEC_OT_PAYMENT_AMT_PMT
,      LATE_PAYMENT_AMT_PMT
,      LATE_PAYMENT_AMT_B_PMT
,      PRIM_LATE_PAYMENT_AMT_PMT
,      SEC_LATE_PAYMENT_AMT_PMT
,      GID
,      NO_DAYS_LATE_CT
,      PAYMENT_AMOUNT_CT
,      PAYMENT_AMOUNT_B_CT
,      PRIM_PAYMENT_AMOUNT_CT
,      SEC_PAYMENT_AMOUNT_CT
,      DISCOUNT_TAKEN_CT
,      DISCOUNT_TAKEN_B_CT
,      PRIM_DISCOUNT_TAKEN_CT
,      SEC_DISCOUNT_TAKEN_CT
,      OT_PAYMENT_AMT_CT
,      OT_PAYMENT_AMT_B_CT
,      PRIM_OT_PAYMENT_AMT_CT
,      SEC_OT_PAYMENT_AMT_CT
,      LATE_PAYMENT_AMT_CT
,      LATE_PAYMENT_AMT_B_CT
,      PRIM_LATE_PAYMENT_AMT_CT
,      SEC_LATE_PAYMENT_AMT_CT
,      NO_DAYS_LATE_PP_CT
,      PAYMENT_AMOUNT_PP_CT
,      PAYMENT_AMOUNT_PP_B_CT
,      PRIM_PAYMENT_AMOUNT_PP_CT
,      SEC_PAYMENT_AMOUNT_PP_CT
,      OT_PAYMENT_AMT_PP_CT
,      OT_PAYMENT_AMT_B_PP_CT
,      PRIM_OT_PAYMENT_AMT_PP_CT
,      SEC_OT_PAYMENT_AMT_PP_CT
,      LATE_PAYMENT_AMT_PP_CT
,      LATE_PAYMENT_AMT_B_PP_CT
,      PRIM_LATE_PAYMENT_AMT_PP_CT
,      SEC_LATE_PAYMENT_AMT_PP_CT
,      NO_DAYS_LATE_PMT_CT
,      PAYMENT_AMOUNT_PMT_CT
,      PAYMENT_AMOUNT_B_PMT_CT
,      PRIM_PAYMENT_AMOUNT_PMT_CT
,      SEC_PAYMENT_AMOUNT_PMT_CT
,      OT_PAYMENT_AMT_PMT_CT
,      OT_PAYMENT_AMT_B_PMT_CT
,      PRIM_OT_PAYMENT_AMT_PMT_CT
,      SEC_OT_PAYMENT_AMT_PMT_CT
,      LATE_PAYMENT_AMT_PMT_CT
,      LATE_PAYMENT_AMT_B_PMT_CT
,      PRIM_LATE_PAYMENT_AMT_PMT_CT
,      SEC_LATE_PAYMENT_AMT_PMT_CT
,      CT
FROM APPS.FII_AP_INV_PAYMENTS_MV;

Dependencies

[top of page]

APPS.FII_AP_INV_PAYMENTS_MV does not reference any database object

APPS.FII_AP_INV_PAYMENTS_MV is referenced by following:

APPS: FII_AP_INV_PAYMENTS_MV