[Home] [Help] [Dependency Information]
Object Name: | ENI_DBI_TOB_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | ENI.ENI_DBI_TOB_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENI_DBI_TOB_MV_N1 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY |
ITEM_CATEGORY_ID
ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_ID | NUMBER | The Customer ID of the Customer for the Sales Order | ||
RESOURCE_ID | NUMBER | The Resource ID for Sales Order | ||
SALES_GRP_ID | NUMBER | The Group ID of the Sales group to which the Sales Person belongs | ||
ORDER_NUMBER | NUMBER | The Order Number of the Sales Order | ||
LINE_NUMBER | VARCHAR2 | (240) | The Line Number of the current Order Number of the Sales Order | |
ITEM_CATEGORY_ID | NUMBER | The ID of the Item Catalog Category to which the Item on which the Sales Order is logged belongs to | ||
ITEM_ID | VARCHAR2 | (25) | The Id of the Item on which the Sales Order is logged | |
BOOKED_DATE | DATE | The Date on which the Sales Order was Booked | ||
SCHEDULE_DATE | DATE | The Scheduled Date for the Sales Order | ||
BOOKED_AMT_G | NUMBER | The Sale Amount for the Current Line in the Current Sales Order in the Primary Currency | ||
BOOKED_AMT_G1 | NUMBER | The Sale Amount for the Current Line in the Current Sales Order in the Secondary Currency | ||
RANK_PROD_ITEM | NUMBER | The Column used to rank the Sales Order for every combination of Product Product Category | ||
RANK_ALL | NUMBER | The Column used to rank the Sales Order based on amount |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_ID
, RESOURCE_ID
, SALES_GRP_ID
, ORDER_NUMBER
, LINE_NUMBER
, ITEM_CATEGORY_ID
, ITEM_ID
, BOOKED_DATE
, SCHEDULE_DATE
, BOOKED_AMT_G
, BOOKED_AMT_G1
, RANK_PROD_ITEM
, RANK_ALL
FROM APPS.ENI_DBI_TOB_MV;
APPS.ENI_DBI_TOB_MV does not reference any database object
APPS.ENI_DBI_TOB_MV is referenced by following:
|
|
|