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

TABLE: APPS.FII_AP_HCAT_B_MV

Object Details
Object Name: FII_AP_HCAT_B_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.FII_AP_HCAT_B_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ROWID_1 ROWID (10)
Row identifier from the fii_ap_inv_holds_b summary table
MARKER CHAR (1)
H for Hold placed and R for Hold Released
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
VARIANCE_COUNT NUMBER

1 indicates invoice placed on hold, -1 indicates hold released of category VARIANCE
PO_MATCHING_COUNT NUMBER

1 indicates invoice placed on hold, -1 indicates hold released of category PO_MATCHING
INVOICE_COUNT NUMBER

1 indicates invoice placed on hold, -1 indicates hold released of category INVOICE
USER_DEFINED_COUNT NUMBER

1 indicates invoice placed on hold, -1 indicates hold released of category USER_DEFINED
OTHER_COUNT NUMBER

1 indicates invoice placed on hold, -1 indicates hold released for categories other than PO MATCHING, INVOICE, USER DEFINED, VARIANCE
Query Text

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


SELECT ROWID_1
,      MARKER
,      ORG_ID
,      SUPPLIER_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      VARIANCE_COUNT
,      PO_MATCHING_COUNT
,      INVOICE_COUNT
,      USER_DEFINED_COUNT
,      OTHER_COUNT
FROM APPS.FII_AP_HCAT_B_MV;

Dependencies

[top of page]

APPS.FII_AP_HCAT_B_MV does not reference any database object

APPS.FII_AP_HCAT_B_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_HCAT_B_MV
Materialized ViewFII_AP_HCAT_I_MV