[Home] [Help] [Dependency Information]
Object Name: | ENI_DBI_TOB_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | ENI_DBI_TOB_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | COMPLETE |
Build Mode: | DEFERRED |
Fast Refreshable: | NO |
ENI_OLTP_ITEM_STAR
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 is not referenced by any database object
|
|
|