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]

MATERIALIZED VIEW: APPS.FII_AP_INV_PAYMENTS_MV

Object Details

Object Name:	FII_AP_INV_PAYMENTS_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	FII_AP_INV_PAYMENTS_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	GENERAL
Refresh Mode:	DEMAND
Refresh Method:	FAST
Build Mode:	DEFERRED
Fast Refreshable:	DIRLOAD_DML

MV Log Dependencies:


FII_AP_INVOICE_B
FII_AP_PAY_SCHED_B
FII_TIME_DAY

[View Source Query]

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 references the following:

APPS: FII_AP_INV_PAYMENTS_MV
FII: FII_AP_INVOICE_B; FII_AP_PAY_SCHED_B; FII_TIME_DAY

APPS.FII_AP_INV_PAYMENTS_MV is not referenced by any database object