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_PMT_SCHEDULES_MV

Object Details

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

M-View Details

Container:	FII_AP_PMT_SCHEDULES_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
ORG_ID	NUMBER	(15)
SUPPLIER_ID	NUMBER	(15)
INVOICE_ID	NUMBER	(15)
PAYMENT_NUM	NUMBER	(15)
BASE_CURRENCY_CODE	VARCHAR2	(25)
DUE_DATE	DATE
INVOICE_CURRENCY_CODE	VARCHAR2	(25)
ORIGINAL_AMT	NUMBER
ORIGINAL_AMT_B	NUMBER
PRIM_ORIGINAL_AMT	NUMBER
SEC_ORIGINAL_AMT	NUMBER
PAST_DUE_AMOUNT	NUMBER
PAST_DUE_AMOUNT_B	NUMBER
PRIM_PAST_DUE_AMOUNT	NUMBER
SEC_PAST_DUE_AMOUNT	NUMBER
AMOUNT_REMAINING	NUMBER
AMOUNT_REMAINING_B	NUMBER
PRIM_AMOUNT_REMAINING	NUMBER
SEC_AMOUNT_REMAINING	NUMBER
DISCOUNT_AVAILABLE	NUMBER
DISCOUNT_AVAILABLE_B	NUMBER
PRIM_DISCOUNT_AVAILABLE	NUMBER
SEC_DISCOUNT_AVAILABLE	NUMBER
DISCOUNT_LOST	NUMBER
DISCOUNT_LOST_B	NUMBER
PRIM_DISCOUNT_LOST	NUMBER
SEC_DISCOUNT_LOST	NUMBER
DISCOUNT_TAKEN	NUMBER
DISCOUNT_TAKEN_B	NUMBER
PRIM_DISCOUNT_TAKEN	NUMBER
SEC_DISCOUNT_TAKEN	NUMBER
AMOUNT_REMAINING_PP	NUMBER
AMOUNT_REMAINING_B_PP	NUMBER
PRIM_AMOUNT_REMAINING_PP	NUMBER
SEC_AMOUNT_REMAINING_PP	NUMBER
AMOUNT_REMAINING_PMT	NUMBER
AMOUNT_REMAINING_B_PMT	NUMBER
PRIM_AMOUNT_REMAINING_PMT	NUMBER
SEC_AMOUNT_REMAINING_PMT	NUMBER
GID	NUMBER
ORIGINAL_AMT_CT	NUMBER
ORIGINAL_AMT_B_CT	NUMBER
PRIM_ORIGINAL_AMT_CT	NUMBER
SEC_ORIGINAL_AMT_CT	NUMBER
PAST_DUE_AMOUNT_CT	NUMBER
PAST_DUE_AMOUNT_B_CT	NUMBER
PRIM_PAST_DUE_AMOUNT_CT	NUMBER
SEC_PAST_DUE_AMOUNT_CT	NUMBER
AMOUNT_REMAINING_CT	NUMBER
AMOUNT_REMAINING_B_CT	NUMBER
PRIM_AMOUNT_REMAINING_CT	NUMBER
SEC_AMOUNT_REMAINING_CT	NUMBER
DISCOUNT_AVAILABLE_CT	NUMBER
DISCOUNT_AVAILABLE_B_CT	NUMBER
PRIM_DISCOUNT_AVAILABLE_CT	NUMBER
SEC_DISCOUNT_AVAILABLE_CT	NUMBER
DISCOUNT_LOST_CT	NUMBER
DISCOUNT_LOST_B_CT	NUMBER
PRIM_DISCOUNT_LOST_CT	NUMBER
SEC_DISCOUNT_LOST_CT	NUMBER
DISCOUNT_TAKEN_CT	NUMBER
DISCOUNT_TAKEN_B_CT	NUMBER
PRIM_DISCOUNT_TAKEN_CT	NUMBER
SEC_DISCOUNT_TAKEN_CT	NUMBER
AMOUNT_REMAINING_PP_CT	NUMBER
AMOUNT_REMAINING_B_PP_CT	NUMBER
PRIM_AMOUNT_REMAINING_PP_CT	NUMBER
SEC_AMOUNT_REMAINING_PP_CT	NUMBER
AMOUNT_REMAINING_PMT_CT	NUMBER
AMOUNT_REMAINING_B_PMT_CT	NUMBER
PRIM_AMOUNT_REMAINING_PMT_CT	NUMBER
SEC_AMOUNT_REMAINING_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
,      ORG_ID
,      SUPPLIER_ID
,      INVOICE_ID
,      PAYMENT_NUM
,      BASE_CURRENCY_CODE
,      DUE_DATE
,      INVOICE_CURRENCY_CODE
,      ORIGINAL_AMT
,      ORIGINAL_AMT_B
,      PRIM_ORIGINAL_AMT
,      SEC_ORIGINAL_AMT
,      PAST_DUE_AMOUNT
,      PAST_DUE_AMOUNT_B
,      PRIM_PAST_DUE_AMOUNT
,      SEC_PAST_DUE_AMOUNT
,      AMOUNT_REMAINING
,      AMOUNT_REMAINING_B
,      PRIM_AMOUNT_REMAINING
,      SEC_AMOUNT_REMAINING
,      DISCOUNT_AVAILABLE
,      DISCOUNT_AVAILABLE_B
,      PRIM_DISCOUNT_AVAILABLE
,      SEC_DISCOUNT_AVAILABLE
,      DISCOUNT_LOST
,      DISCOUNT_LOST_B
,      PRIM_DISCOUNT_LOST
,      SEC_DISCOUNT_LOST
,      DISCOUNT_TAKEN
,      DISCOUNT_TAKEN_B
,      PRIM_DISCOUNT_TAKEN
,      SEC_DISCOUNT_TAKEN
,      AMOUNT_REMAINING_PP
,      AMOUNT_REMAINING_B_PP
,      PRIM_AMOUNT_REMAINING_PP
,      SEC_AMOUNT_REMAINING_PP
,      AMOUNT_REMAINING_PMT
,      AMOUNT_REMAINING_B_PMT
,      PRIM_AMOUNT_REMAINING_PMT
,      SEC_AMOUNT_REMAINING_PMT
,      GID
,      ORIGINAL_AMT_CT
,      ORIGINAL_AMT_B_CT
,      PRIM_ORIGINAL_AMT_CT
,      SEC_ORIGINAL_AMT_CT
,      PAST_DUE_AMOUNT_CT
,      PAST_DUE_AMOUNT_B_CT
,      PRIM_PAST_DUE_AMOUNT_CT
,      SEC_PAST_DUE_AMOUNT_CT
,      AMOUNT_REMAINING_CT
,      AMOUNT_REMAINING_B_CT
,      PRIM_AMOUNT_REMAINING_CT
,      SEC_AMOUNT_REMAINING_CT
,      DISCOUNT_AVAILABLE_CT
,      DISCOUNT_AVAILABLE_B_CT
,      PRIM_DISCOUNT_AVAILABLE_CT
,      SEC_DISCOUNT_AVAILABLE_CT
,      DISCOUNT_LOST_CT
,      DISCOUNT_LOST_B_CT
,      PRIM_DISCOUNT_LOST_CT
,      SEC_DISCOUNT_LOST_CT
,      DISCOUNT_TAKEN_CT
,      DISCOUNT_TAKEN_B_CT
,      PRIM_DISCOUNT_TAKEN_CT
,      SEC_DISCOUNT_TAKEN_CT
,      AMOUNT_REMAINING_PP_CT
,      AMOUNT_REMAINING_B_PP_CT
,      PRIM_AMOUNT_REMAINING_PP_CT
,      SEC_AMOUNT_REMAINING_PP_CT
,      AMOUNT_REMAINING_PMT_CT
,      AMOUNT_REMAINING_B_PMT_CT
,      PRIM_AMOUNT_REMAINING_PMT_CT
,      SEC_AMOUNT_REMAINING_PMT_CT
,      CT
FROM APPS.FII_AP_PMT_SCHEDULES_MV;

Dependencies

[top of page]

APPS.FII_AP_PMT_SCHEDULES_MV references the following:

APPS: FII_AP_PMT_SCHEDULES_MV
FII: FII_AP_INVOICE_B; FII_AP_PAY_SCHED_B; FII_TIME_DAY

APPS.FII_AP_PMT_SCHEDULES_MV is not referenced by any database object