[Home] [Help] [Dependency Information]
Object Name: | MLOG$_ASO_BI_QUOTE_LINES_A |
---|---|
Object Type: | TABLE |
Owner: | ASO |
Subobject Name: | |
Status: | VALID |
snapshot log for master table ASO.ASO_BI_QUOTE_LINES_ALL
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 60 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGREEMENT_ID | NUMBER | |||
CHARGE_PERIODICITY_CODE | VARCHAR2 | (3) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CUST_ACCOUNT_ID | NUMBER | |||
CUST_PARTY_ID | NUMBER | |||
FUNCTIONAL_CONVERSION_RATE | NUMBER | |||
FUNCTIONAL_CURRENCY | VARCHAR2 | (15) | ||
INVENTORY_ITEM_ID | NUMBER | |||
INVOICE_TO_CUST_ACCOUNT_ID | NUMBER | |||
INVOICE_TO_CUST_ACCOUNT_ID_HDR | NUMBER | |||
LINE_CATEGORY_CODE | VARCHAR2 | (30) | ||
LINE_QUOTE_VALUE | NUMBER | |||
LINE_VALUE | NUMBER | |||
MARKETING_SOURCE_CODE_ID | NUMBER | |||
MARKETING_SOURCE_CODE_ID_HDR | NUMBER | |||
MINISITE_ID | NUMBER | |||
MINISITE_ID_HDR | NUMBER | |||
ORDER_CREATION_DATE | DATE | |||
ORDER_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
ORG_ID | NUMBER | |||
PUBLISH_FLAG | VARCHAR2 | (1) | ||
QUANTITY | NUMBER | |||
QUOTE_CREATION_DATE | DATE | |||
QUOTE_EXPIRATION_DATE | DATE | |||
QUOTE_HEADER_ID | NUMBER | |||
QUOTE_LAST_UPDATE_DATE | DATE | |||
QUOTE_LINE_ID | NUMBER | |||
QUOTE_NUMBER | NUMBER | |||
QUOTE_SOURCE_CODE | VARCHAR2 | (240) | ||
QUOTE_STATUS_ID | NUMBER | |||
QUOTE_VERSION | NUMBER | |||
REPORTING_CONVERSION_RATE | NUMBER | |||
REPORTING_CURRENCY | VARCHAR2 | (15) | ||
RESOURCE_GRP_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
SALES_CHANNEL_CODE | VARCHAR2 | (30) | ||
SEC_CONVERSION_RATE | NUMBER | |||
SHIPMENT_ID | NUMBER | |||
TOP_INVENTORY_ITEM_ID | NUMBER | |||
TOP_ORGANIZATION_ID | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) |
Cut, paste (and edit) the following text to query this object:
SELECT AGREEMENT_ID
, CHARGE_PERIODICITY_CODE
, CURRENCY_CODE
, CUST_ACCOUNT_ID
, CUST_PARTY_ID
, FUNCTIONAL_CONVERSION_RATE
, FUNCTIONAL_CURRENCY
, INVENTORY_ITEM_ID
, INVOICE_TO_CUST_ACCOUNT_ID
, INVOICE_TO_CUST_ACCOUNT_ID_HDR
, LINE_CATEGORY_CODE
, LINE_QUOTE_VALUE
, LINE_VALUE
, MARKETING_SOURCE_CODE_ID
, MARKETING_SOURCE_CODE_ID_HDR
, MINISITE_ID
, MINISITE_ID_HDR
, ORDER_CREATION_DATE
, ORDER_ID
, ORGANIZATION_ID
, ORG_ID
, PUBLISH_FLAG
, QUANTITY
, QUOTE_CREATION_DATE
, QUOTE_EXPIRATION_DATE
, QUOTE_HEADER_ID
, QUOTE_LAST_UPDATE_DATE
, QUOTE_LINE_ID
, QUOTE_NUMBER
, QUOTE_SOURCE_CODE
, QUOTE_STATUS_ID
, QUOTE_VERSION
, REPORTING_CONVERSION_RATE
, REPORTING_CURRENCY
, RESOURCE_GRP_ID
, RESOURCE_ID
, SALES_CHANNEL_CODE
, SEC_CONVERSION_RATE
, SHIPMENT_ID
, TOP_INVENTORY_ITEM_ID
, TOP_ORGANIZATION_ID
, UOM_CODE
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM ASO.MLOG$_ASO_BI_QUOTE_LINES_A;
ASO.MLOG$_ASO_BI_QUOTE_LINES_A does not reference any database object
ASO.MLOG$_ASO_BI_QUOTE_LINES_A is referenced by following:
|
|
|