[Home] [Help] [Dependency Information]
Object Name: | ASO_BI_QLIN_L1_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QROWID | ROWID | (10) | For fast refreshability purpose | |
SROWID | ROWID | (10) | For fast refreshability purpose | |
RESOURCE_ID | NUMBER | Resoucre id | ||
RESOURCE_GRP_ID | NUMBER | Resource group id | ||
LINE_AMOUNT | NUMBER | Line amount after proper currency conversion in Primary Currency | ||
SEC_LINE_AMOUNT | NUMBER | Line amount after proper currency conversion in Secondary Currency | ||
CATEGORY_ID | NUMBER | Product category id | ||
MASTER_ID | VARCHAR2 | (25) | Inventory item id | |
QUOTE_CREATION_DATE | DATE | Quote creation date | ||
ORDER_CREATION_DATE | DATE | Order creation date | ||
QUOTE_EXPIRATION_DATE | DATE | Quote expiration date | ||
ORDER_ID | NUMBER | Order Id |
Cut, paste (and edit) the following text to query this object:
SELECT QROWID
, SROWID
, RESOURCE_ID
, RESOURCE_GRP_ID
, LINE_AMOUNT
, SEC_LINE_AMOUNT
, CATEGORY_ID
, MASTER_ID
, QUOTE_CREATION_DATE
, ORDER_CREATION_DATE
, QUOTE_EXPIRATION_DATE
, ORDER_ID
FROM APPS.ASO_BI_QLIN_L1_MV;
APPS.ASO_BI_QLIN_L1_MV does not reference any database object
APPS.ASO_BI_QLIN_L1_MV is referenced by following:
|
|
|