[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FII_AP_LIA_B_MV |
|---|---|
| Object Type: | MATERIALIZED VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Container: | FII_AP_LIA_B_MV |
|---|---|
| Updatable: | N |
| Rewrite Enabled: | N |
| Rewrite Capability: | TEXTMATCH |
| Refresh Mode: | DEMAND |
| Refresh Method: | FAST |
| Build Mode: | DEFERRED |
| Fast Refreshable: | DIRLOAD_DML |
FII_AP_AGING_BKTS_B
FII_AP_DUE_COUNTS_B
FII_AP_INVOICE_B
FII_AP_PAY_SCHED_B
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MARKER | NUMBER | H for Hold placed and R for Hold Released | ||
| ROW_ID | ROWID | (10) | Row identifier from the fii_ap_inv_holds_b summary table | |
| PS_ROW_ID | ROWID | (10) | Row identifier from the fii_ap_pay_sched_b table | |
| ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
| SUPPLIER_ID | NUMBER | (15) | Supplier Identifier | |
| TIME_ID | NUMBER | Time identifier | ||
| UNPAID_AMT_B | NUMBER | Total unpaid invoice amounts in base currency | ||
| PRIM_UNPAID_AMT | NUMBER | Total unpaid invoice amounts in primary currency | ||
| SEC_UNPAID_AMT | NUMBER | Total unpaid invoice amounts in secondary currency | ||
| UNPAID_COUNT | NUMBER | Total number of unpaid invoices | ||
| DUE_COUNT | NUMBER | Total number of unpaid invoices which are due | ||
| PAST_DUE_AMT_B | NUMBER | Total past due invoice amounts in base currency | ||
| PRIM_PAST_DUE_AMT | NUMBER | Total past due invoice amounts in primary currency | ||
| SEC_PAST_DUE_AMT | NUMBER | Toal past due invoice amounts in secondary currency | ||
| PAST_DUE_COUNT | NUMBER | Total number of invoices entered which are past due | ||
| PAYMENT_AMT_B | NUMBER | Total payment amount in base currency | ||
| PRIM_PAYMENT_AMT | NUMBER | Total payment amount in primary currency | ||
| SEC_PAYMENT_AMT | NUMBER | Total payment amount in secondary currency | ||
| DISCOUNT_OFFERED_B | NUMBER | Total discounts offered in base currency | ||
| PRIM_DISCOUNT_OFFERED | NUMBER | Total discounts in primary currency | ||
| SEC_DISCOUNT_OFFERED | NUMBER | Total discounts offered in secondary currency | ||
| DISCOUNT_REMAINING_B | NUMBER | Total discounts remaining in base currency | ||
| PRIM_DISCOUNT_REMAINING | NUMBER | Total discounts remaining in primary currency | ||
| SEC_DISCOUNT_REMAINING | NUMBER | Total discounts remaining in secondary currency | ||
| DISCOUNT_TAKEN_B | NUMBER | Total discounts taken in base currency | ||
| PRIM_DISCOUNT_TAKEN | NUMBER | Total discounts taken in primary currency | ||
| SEC_DISCOUNT_TAKEN | NUMBER | Total discounts taken in secondary currency | ||
| DISCOUNT_LOST_B | NUMBER | Total discounts lost in base currency | ||
| PRIM_DISCOUNT_LOST | NUMBER | Total discounts lost in primary currency | ||
| SEC_DISCOUNT_LOST | NUMBER | Total discounts lost in secondary currency | ||
| DUE_BUCKET1_B | NUMBER | Total invoice amounts Due After 30 Days in base currency | ||
| PRIM_DUE_BUCKET1 | NUMBER | Total invoice amounts Due After 30 Days in primary currency | ||
| SEC_DUE_BUCKET1 | NUMBER | Total invoice amounts Due After 30 Days in secondary currency | ||
| DUE_BUCKET1_COUNT | NUMBER | Total number of invoices Due After 30 Days | ||
| DUE_BUCKET2_B | NUMBER | Total invoice amounts Due in 16 - 30 Days in base currency | ||
| PRIM_DUE_BUCKET2 | NUMBER | Total invoice amounts Due in 16 - 30 Days in primary currency | ||
| SEC_DUE_BUCKET2 | NUMBER | Total invoice amounts Due in 16 - 30 Days in secondary currency | ||
| DUE_BUCKET2_COUNT | NUMBER | Total number of invoices Due in 16 - 30 Days | ||
| DUE_BUCKET3_B | NUMBER | Total invoice amounts Due in 1 - 15 Days in base currency | ||
| PRIM_DUE_BUCKET3 | NUMBER | Total invoice amounts Due in 1 - 15 Days in primary currency | ||
| SEC_DUE_BUCKET3 | NUMBER | Total invoice amounts Due in 1 - 15 Days in secondary currency | ||
| DUE_BUCKET3_COUNT | NUMBER | Total number of invoices Due in 1 - 15 Days | ||
| PAST_DUE_BUCKET1_B | NUMBER | Total invoice amounts Past Due After 30 Days in base currency | ||
| PRIM_PAST_DUE_BUCKET1 | NUMBER | Total invoice amounts Past Due After 30 Days in primary currency | ||
| SEC_PAST_DUE_BUCKET1 | NUMBER | Total invoice amounts Past Due After 30 Days in secondary currency | ||
| PAST_DUE_BUCKET1_COUNT | NUMBER | Total number of invoices Past Due After 30 Days | ||
| PAST_DUE_BUCKET2_B | NUMBER | Total invoice amounts Past Due in 16 - 30 Days in base currency | ||
| PRIM_PAST_DUE_BUCKET2 | NUMBER | Total invoice amounts Past Due in 16 - 30 Days in primary currency | ||
| SEC_PAST_DUE_BUCKET2 | NUMBER | Total invoice amounts Past Due in 16 - 30 Days in secondary currency | ||
| PAST_DUE_BUCKET2_COUNT | NUMBER | Total number of invoices Past Due in 16 - 30 Days | ||
| PAST_DUE_BUCKET3_B | NUMBER | Total invoice amounts Past Due in 1 - 15 Days in base currency | ||
| PRIM_PAST_DUE_BUCKET3 | NUMBER | Total invoice amounts Past Due in 1 - 15 Days in primary currency | ||
| SEC_PAST_DUE_BUCKET3 | NUMBER | Total invoice amounts Past Due in 1 - 15 Days in secondary currency | ||
| PAST_DUE_BUCKET3_COUNT | NUMBER | Total number of invoices Past Due in 1 - 15 Days | ||
| ON_TIME_PAYMENT_AMT_B | NUMBER | Total on time payment amounts in base currency | ||
| PRIM_ON_TIME_PAYMENT_AMT | NUMBER | Total on time payment amounts in primary currency | ||
| SEC_ON_TIME_PAYMENT_AMT | NUMBER | Total on time payment amounts in secondary currency | ||
| LATE_PAYMENT_AMT_B | NUMBER | Total late payment amounts in base currency | ||
| PRIM_LATE_PAYMENT_AMT | NUMBER | Total late payment amounts in primary currency | ||
| SEC_LATE_PAYMENT_AMT | NUMBER | Total late payment amounts in secondary currency | ||
| WT_OPEN_DUE_AMT_B | NUMBER | Total weighted due amount in base currency | ||
| WT_OPEN_DUE_AMT_PRIM_G | NUMBER | Total weighted due amount in primary currency | ||
| WT_OPEN_DUE_AMT_SEC_G | NUMBER | Total weighted due amount in secondary currency | ||
| WT_OPEN_PAST_DUE_AMT_B | NUMBER | Total weighted past due amount in base currency | ||
| WT_OPEN_PAST_DUE_AMT_PRIM_G | NUMBER | Total weighted past due amount in primary currency | ||
| WT_OPEN_PAST_DUE_AMT_SEC_G | NUMBER | Total weighted past due amount in secondary currency |
Cut, paste (and edit) the following text to query this object:
SELECT MARKER
, ROW_ID
, PS_ROW_ID
, ORG_ID
, SUPPLIER_ID
, TIME_ID
, UNPAID_AMT_B
, PRIM_UNPAID_AMT
, SEC_UNPAID_AMT
, UNPAID_COUNT
, DUE_COUNT
, PAST_DUE_AMT_B
, PRIM_PAST_DUE_AMT
, SEC_PAST_DUE_AMT
, PAST_DUE_COUNT
, PAYMENT_AMT_B
, PRIM_PAYMENT_AMT
, SEC_PAYMENT_AMT
, DISCOUNT_OFFERED_B
, PRIM_DISCOUNT_OFFERED
, SEC_DISCOUNT_OFFERED
, DISCOUNT_REMAINING_B
, PRIM_DISCOUNT_REMAINING
, SEC_DISCOUNT_REMAINING
, DISCOUNT_TAKEN_B
, PRIM_DISCOUNT_TAKEN
, SEC_DISCOUNT_TAKEN
, DISCOUNT_LOST_B
, PRIM_DISCOUNT_LOST
, SEC_DISCOUNT_LOST
, DUE_BUCKET1_B
, PRIM_DUE_BUCKET1
, SEC_DUE_BUCKET1
, DUE_BUCKET1_COUNT
, DUE_BUCKET2_B
, PRIM_DUE_BUCKET2
, SEC_DUE_BUCKET2
, DUE_BUCKET2_COUNT
, DUE_BUCKET3_B
, PRIM_DUE_BUCKET3
, SEC_DUE_BUCKET3
, DUE_BUCKET3_COUNT
, PAST_DUE_BUCKET1_B
, PRIM_PAST_DUE_BUCKET1
, SEC_PAST_DUE_BUCKET1
, PAST_DUE_BUCKET1_COUNT
, PAST_DUE_BUCKET2_B
, PRIM_PAST_DUE_BUCKET2
, SEC_PAST_DUE_BUCKET2
, PAST_DUE_BUCKET2_COUNT
, PAST_DUE_BUCKET3_B
, PRIM_PAST_DUE_BUCKET3
, SEC_PAST_DUE_BUCKET3
, PAST_DUE_BUCKET3_COUNT
, ON_TIME_PAYMENT_AMT_B
, PRIM_ON_TIME_PAYMENT_AMT
, SEC_ON_TIME_PAYMENT_AMT
, LATE_PAYMENT_AMT_B
, PRIM_LATE_PAYMENT_AMT
, SEC_LATE_PAYMENT_AMT
, WT_OPEN_DUE_AMT_B
, WT_OPEN_DUE_AMT_PRIM_G
, WT_OPEN_DUE_AMT_SEC_G
, WT_OPEN_PAST_DUE_AMT_B
, WT_OPEN_PAST_DUE_AMT_PRIM_G
, WT_OPEN_PAST_DUE_AMT_SEC_G
FROM APPS.FII_AP_LIA_B_MV;
APPS
FII_AP_LIA_B_MV
FII
FII_AP_AGING_BKTS_B
FII_AP_DUE_COUNTS_B
FII_AP_INVOICE_B
FII_AP_PAY_SCHED_B
APPS
FII_AP_LIA_I_MV
|
|
|
|