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_PMT_SCHEDULES_MV

Object Details

Object Name:	FII_AP_PMT_SCHEDULES_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.FII_AP_PMT_SCHEDULES_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_PMT_SCHEDUL	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("ORG_ID") SYS_OP_MAP_NONNULL("SUPPLIER_ID") SYS_OP_MAP_NONNULL("INVOICE_ID") SYS_OP_MAP_NONNULL("PAYMENT_NUM") SYS_OP_MAP_NONNULL("BASE_CURRENCY_CODE") SYS_OP_MAP_NONNULL("DUE_DATE") SYS_OP_MAP_NONNULL("INVOICE_CURRENCY_CODE") 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_PMT_SCHEDULES_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_TYPE_ID TIME_ID ORG_ID
FII_AP_PMT_SCHEDULES_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
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 does not reference any database object

APPS.FII_AP_PMT_SCHEDULES_MV is referenced by following:

APPS: FII_AP_PMT_SCHEDULES_MV