DBA Data[Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.FII_AP_INV_B_MV

Object Details
Object Name: FII_AP_INV_B_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: FII_AP_INV_B_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: NONE
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: DEFERRED
Fast Refreshable: NO
MV Log Dependencies:

FII_AP_HHIST_IB_MV
     BIS_SYSTEM_DATE
     FII_AP_HHIST_I_MV
          FII_AP_HHIST_B_MV
               FII_AP_HOLD_HIST_B

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
Operating Unit Identifier
SUPPLIER_ID NUMBER (15)
Supplier Identifier
INVOICE_ID NUMBER (15)
Invoice Identifier
INVOICE_NUMBER VARCHAR2 (50)
Invoice Number
INVOICE_TYPE VARCHAR2 (25)
Invoice Type
INVOICE_DATE DATE

Invoice Date
ENTERED_DATE DATE

Invoice entered date
DUE_DATE DATE

Invoice due date
DAYS_PAST_DUE NUMBER

Number of days past due
TRX_CURRENCY_CODE VARCHAR2 (25)
Transaction currency code
INVOICE_AMT_T NUMBER

Invoice amount in transaction currency
INVOICE_AMT_B NUMBER

Invoice amount in base currency
INVOICE_AMT_PRIM_G NUMBER

Invoice amount in primary global currency
INVOICE_AMT_SEC_G NUMBER

Invoice amount in secondary global currency
UNPAID_AMT_B NUMBER

Unpaid amount in base currency
UNPAID_AMT_PRIM_G NUMBER

Unpaid amount in primary global currency
UNPAID_AMT_SEC_G NUMBER

Unpaid amount in secondary global currency
PAST_DUE_AMT_B NUMBER

Past due amount in base currency
PAST_DUE_AMT_PRIM_G NUMBER

Past due amount in primary global currency
PAST_DUE_AMT_SEC_G NUMBER

Past due amount in secondary global currency
ON_HOLD VARCHAR2 (1)
Flag that denotes whether the invoice is on hold or not. Y - on hold, N - not on hold
DAYS_ON_HOLD NUMBER

Number of days the invoice was on hold throughout its lifecycle
DISCOUNT_LOST_B NUMBER

Discount lost amount in base currency
DISCOUNT_LOST_PRIM_G NUMBER

Discount lost amount in primary global currency
DISCOUNT_LOST_SEC_G NUMBER

Discount lost amount in secondary global currency
TERMS_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORG_ID
,      SUPPLIER_ID
,      INVOICE_ID
,      INVOICE_NUMBER
,      INVOICE_TYPE
,      INVOICE_DATE
,      ENTERED_DATE
,      DUE_DATE
,      DAYS_PAST_DUE
,      TRX_CURRENCY_CODE
,      INVOICE_AMT_T
,      INVOICE_AMT_B
,      INVOICE_AMT_PRIM_G
,      INVOICE_AMT_SEC_G
,      UNPAID_AMT_B
,      UNPAID_AMT_PRIM_G
,      UNPAID_AMT_SEC_G
,      PAST_DUE_AMT_B
,      PAST_DUE_AMT_PRIM_G
,      PAST_DUE_AMT_SEC_G
,      ON_HOLD
,      DAYS_ON_HOLD
,      DISCOUNT_LOST_B
,      DISCOUNT_LOST_PRIM_G
,      DISCOUNT_LOST_SEC_G
,      TERMS_ID
FROM APPS.FII_AP_INV_B_MV;

Dependencies

[top of page]

APPS.FII_AP_INV_B_MV references the following:

SchemaAPPS
TableFII_AP_HHIST_IB_MV
Materialized ViewFII_AP_HHIST_IB_MV
TableFII_AP_INV_B_MV
SchemaFII
TableFII_AP_INVOICE_B
TableFII_AP_PAY_SCHED_B

APPS.FII_AP_INV_B_MV is not referenced by any database object