[Home] [Help] [Dependency Information]
Object Name: | OE_INIT_CREDIT_SUMM_GTT |
---|---|
Object Type: | TABLE |
Owner: | ONT |
FND Design Data: | ONT.OE_INIT_CREDIT_SUMM_GTT |
Subobject Name: | |
Status: | VALID |
ONT.OE_INIT_CREDIT_SUMM_GTT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ORDERED_QUANTITY | NUMBER | |||
LINE_UNIT_SELLING_PRICE | NUMBER | |||
ORDER_INVOICE_TO_ORG_ID | NUMBER | |||
RL_AMOUNT | NUMBER | |||
RL_QUANTITY_ORDERED | NUMBER | |||
ORDER_ORG_ID | NUMBER | |||
ORDER_TRANSACTIONAL_CURR_CODE | VARCHAR2 | (15) | ||
LINE_SCHEDULE_SHIP_DATE | DATE | |||
LINE_REQUEST_DATE | DATE | |||
ORDER_REQUEST_DATE | DATE | |||
ORDER_CREATION_DATE | DATE | |||
LINE_TAX_VALUE | NUMBER | |||
LINE_INVOICE_TO_ORG_ID | NUMBER | |||
LINE_LINE_CATEGORY_CODE | VARCHAR2 | (30) | ||
LINE_INVOICED_QUANTITY | NUMBER | |||
LINE_PAYMENT_TYPE_CODE | VARCHAR2 | (30) | ||
ORDER_PAYMENT_TYPE_CODE | VARCHAR2 | (30) | ||
ORDER_ORDER_NUMBER | NUMBER | |||
LINE_LINE_ID | NUMBER | |||
ORDER_HEADER_ID | NUMBER | |||
LINE_HEADER_ID | NUMBER | |||
ORDER_CUST_ACCOUNT_ID | NUMBER | |||
ORDER_PARTY_ID | NUMBER | |||
LINE_CUST_ACCOUNT_ID | NUMBER | |||
LINE_PARTY_ID | NUMBER | |||
INTERFACE_LINE_ATTRIBUTE6 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_ORDERED_QUANTITY
, LINE_UNIT_SELLING_PRICE
, ORDER_INVOICE_TO_ORG_ID
, RL_AMOUNT
, RL_QUANTITY_ORDERED
, ORDER_ORG_ID
, ORDER_TRANSACTIONAL_CURR_CODE
, LINE_SCHEDULE_SHIP_DATE
, LINE_REQUEST_DATE
, ORDER_REQUEST_DATE
, ORDER_CREATION_DATE
, LINE_TAX_VALUE
, LINE_INVOICE_TO_ORG_ID
, LINE_LINE_CATEGORY_CODE
, LINE_INVOICED_QUANTITY
, LINE_PAYMENT_TYPE_CODE
, ORDER_PAYMENT_TYPE_CODE
, ORDER_ORDER_NUMBER
, LINE_LINE_ID
, ORDER_HEADER_ID
, LINE_HEADER_ID
, ORDER_CUST_ACCOUNT_ID
, ORDER_PARTY_ID
, LINE_CUST_ACCOUNT_ID
, LINE_PARTY_ID
, INTERFACE_LINE_ATTRIBUTE6
FROM ONT.OE_INIT_CREDIT_SUMM_GTT;
ONT.OE_INIT_CREDIT_SUMM_GTT does not reference any database object
ONT.OE_INIT_CREDIT_SUMM_GTT is referenced by following:
|
|
|