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

TABLE: APPS.FII_AP_INV_B_MV

Object Details
Object Name: FII_AP_INV_B_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.FII_AP_INV_B_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_AP_INV_B_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORG_ID
FII_AP_INV_B_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSUPPLIER_ID
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 does not reference any database object

APPS.FII_AP_INV_B_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_INV_B_MV