[Home] [Help] [Dependency Information]
Object Name: | FII_AP_PMT_SCHEDULES_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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 |
FII_AP_INVOICE_B
FII_AP_PAY_SCHED_B
FII_TIME_DAY
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 is not referenced by any database object
|
|
|