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

MATERIALIZED VIEW: APPS.FII_AP_HATY_XB_MV

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

FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
Operating unit identifier
SUPPLIER_ID NUMBER (15)
Supplier Identifier
TIME_ID NUMBER

Time identifier
PERIOD_TYPE_ID NUMBER

Period type Identifier
GID NUMBER

Grouping identifier
INV_ON_HOLD_AMT_WTD_B NUMBER

Week to date Amount of Invoices on Hold in base currency
INV_ON_HOLD_AMT_MTD_B NUMBER

Month to date Amount of Invoices on Hold in base currency
INV_ON_HOLD_AMT_QTD_B NUMBER

Quarter to date Amount of Invoices on Hold in base currency
INV_ON_HOLD_AMT_YTD_B NUMBER

Year to date Amount of Invoices on Hold in base currency
INV_ON_HOLD_AMT_WTD_PRIM_G NUMBER

Week to date Amount of Invoices on Hold in primary currency
INV_ON_HOLD_AMT_MTD_PRIM_G NUMBER

Month to date Amount of Invoices on Hold in primary currency
INV_ON_HOLD_AMT_QTD_PRIM_G NUMBER

Quarter to date Amount of Invoices on Hold in primary currency
INV_ON_HOLD_AMT_YTD_PRIM_G NUMBER

Year to date Amount of Invoices on Hold in primary currency
INV_ON_HOLD_AMT_WTD_SEC_G NUMBER

Week to date Amount of Invoices on Hold in Secondary currency
INV_ON_HOLD_AMT_MTD_SEC_G NUMBER

Month to date Amount of Invoices on Hold in Secondary currency
INV_ON_HOLD_AMT_QTD_SEC_G NUMBER

Quarter to date Amount of Invoices on Hold in Secondary currency
INV_ON_HOLD_AMT_YTD_SEC_G NUMBER

Year to date Amount of Invoices on Hold in base currency
INV_ON_HOLD_COUNT_WTD NUMBER

Week to date number of invoices on hold
INV_ON_HOLD_COUNT_MTD NUMBER

Month to date numberof invoices on hold
INV_ON_HOLD_COUNT_QTD NUMBER

Quarter to date number of invoices on hold
INV_ON_HOLD_COUNT_YTD NUMBER

Year to date number of invoices on hold in year
DAYS_ON_HOLD_WTD NUMBER

Week to date days on Hold
DAYS_ON_HOLD_MTD NUMBER

Month to date days on Hold
DAYS_ON_HOLD_QTD NUMBER

Quarter to date days on Hold
DAYS_ON_HOLD_YTD NUMBER

Year to date days on Hold
NO_OF_HOLDS_PLACED NUMBER

Total number of holds placed
Query Text

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


SELECT ORG_ID
,      SUPPLIER_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      GID
,      INV_ON_HOLD_AMT_WTD_B
,      INV_ON_HOLD_AMT_MTD_B
,      INV_ON_HOLD_AMT_QTD_B
,      INV_ON_HOLD_AMT_YTD_B
,      INV_ON_HOLD_AMT_WTD_PRIM_G
,      INV_ON_HOLD_AMT_MTD_PRIM_G
,      INV_ON_HOLD_AMT_QTD_PRIM_G
,      INV_ON_HOLD_AMT_YTD_PRIM_G
,      INV_ON_HOLD_AMT_WTD_SEC_G
,      INV_ON_HOLD_AMT_MTD_SEC_G
,      INV_ON_HOLD_AMT_QTD_SEC_G
,      INV_ON_HOLD_AMT_YTD_SEC_G
,      INV_ON_HOLD_COUNT_WTD
,      INV_ON_HOLD_COUNT_MTD
,      INV_ON_HOLD_COUNT_QTD
,      INV_ON_HOLD_COUNT_YTD
,      DAYS_ON_HOLD_WTD
,      DAYS_ON_HOLD_MTD
,      DAYS_ON_HOLD_QTD
,      DAYS_ON_HOLD_YTD
,      NO_OF_HOLDS_PLACED
FROM APPS.FII_AP_HATY_XB_MV;

Dependencies

[top of page]

APPS.FII_AP_HATY_XB_MV references the following:

SchemaAPPS
TableFII_AP_HATY_XB_MV
Materialized ViewFII_AP_HHIST_IB_MV
TableFII_AP_HHIST_IB_MV
SchemaFII
TableFII_AP_INVOICE_B
TableFII_AP_INV_HOLDS_B
TableFII_TIME_DAY

APPS.FII_AP_HATY_XB_MV is not referenced by any database object