[Home] [Help] [Dependency Information]
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 |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.FII_AP_PMT_SCHEDULES_MV does not reference any database object
APPS.FII_AP_PMT_SCHEDULES_MV is referenced by following:
|
|
|