[Home] [Help] [Dependency Information]
Object Name: | BIM_I_ORD_INT_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.BIM_I_ORD_INT_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIM_I_ORD_INT_MV_N1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
VBH_CATEGORY_ID
TRANSACTION_CREATE_DATE SOURCE_CODE_ID OBJECT_TYPE OBJECT_ID OBJECT_REGION OBJECT_STATUS OBJECT_COUNTRY |
I_SNAP$_BIM_I_ORD_INT_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_TX_DATA |
SYS_OP_MAP_NONNULL("TRANSACTION_CREATE_DATE")
SYS_OP_MAP_NONNULL("SOURCE_CODE_ID") SYS_OP_MAP_NONNULL("OBJECT_ID") SYS_OP_MAP_NONNULL("OBJECT_TYPE") SYS_OP_MAP_NONNULL("VBH_CATEGORY_ID") SYS_OP_MAP_NONNULL("CHILD_OBJECT_ID") SYS_OP_MAP_NONNULL("CHILD_OBJECT_TYPE") SYS_OP_MAP_NONNULL("OBJECT_REGION") SYS_OP_MAP_NONNULL("OBJECT_COUNTRY") SYS_OP_MAP_NONNULL("OBJECT_STATUS") SYS_OP_MAP_NONNULL("ACTIVITY_ID") |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UMARK | NUMBER | |||
TRANSACTION_CREATE_DATE | DATE | |||
SOURCE_CODE_ID | NUMBER | |||
OBJECT_ID | NUMBER | |||
OBJECT_TYPE | VARCHAR2 | (30) | ||
VBH_CATEGORY_ID | NUMBER | |||
METRIC_TYPE | CHAR | (5) | ||
CHILD_OBJECT_ID | NUMBER | |||
CHILD_OBJECT_TYPE | VARCHAR2 | (30) | ||
OBJECT_REGION | VARCHAR2 | (30) | ||
OBJECT_COUNTRY | VARCHAR2 | (30) | ||
OBJECT_STATUS | VARCHAR2 | (30) | ||
ACTIVITY_ID | NUMBER | |||
CATEGORY_FLAG | CHAR | (1) | ||
BOOKED_AMT_F | NUMBER | |||
BOOKED_AMT_F_C | NUMBER | |||
INVOICED_AMT_F | NUMBER | |||
INVOICED_AMT_F_C | NUMBER | |||
BOOKED_AMT_S | NUMBER | |||
BOOKED_AMT_S_C | NUMBER | |||
INVOICED_AMT_S | NUMBER | |||
INVOICED_AMT_S_C | NUMBER | |||
ALL_C | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT UMARK
, TRANSACTION_CREATE_DATE
, SOURCE_CODE_ID
, OBJECT_ID
, OBJECT_TYPE
, VBH_CATEGORY_ID
, METRIC_TYPE
, CHILD_OBJECT_ID
, CHILD_OBJECT_TYPE
, OBJECT_REGION
, OBJECT_COUNTRY
, OBJECT_STATUS
, ACTIVITY_ID
, CATEGORY_FLAG
, BOOKED_AMT_F
, BOOKED_AMT_F_C
, INVOICED_AMT_F
, INVOICED_AMT_F_C
, BOOKED_AMT_S
, BOOKED_AMT_S_C
, INVOICED_AMT_S
, INVOICED_AMT_S_C
, ALL_C
FROM APPS.BIM_I_ORD_INT_MV;
APPS.BIM_I_ORD_INT_MV does not reference any database object
APPS.BIM_I_ORD_INT_MV is referenced by following:
|
|
|