[Home] [Help] [Dependency Information]
Object Name: | CST_LC_RAE_EVENTS_GT |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.CST_LC_RAE_EVENTS_GT |
Subobject Name: | |
Status: | VALID |
BOM.CST_LC_RAE_EVENTS_GT 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 |
---|---|---|---|---|
LCM_TRANSACTION_ID | NUMBER | |||
ACCOUNTING_EVENT_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
RCV_TRANSACTION_ID | NUMBER | |||
EVENT_TYPE_ID | NUMBER | |||
EVENT_SOURCE | VARCHAR2 | (25) | ||
EVENT_SOURCE_ID | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | |||
ORG_ID | NUMBER | |||
TRANSFER_ORG_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
TRANSFER_ORGANIZATION_ID | NUMBER | |||
DEBIT_ACCOUNT_ID | NUMBER | |||
CREDIT_ACCOUNT_ID | NUMBER | |||
DEBIT_ACCOUNTING_LINE_TYPE | VARCHAR2 | (30) | ||
CREDIT_ACCOUNTING_LINE_TYPE | VARCHAR2 | (30) | ||
TRANSACTION_DATE | DATE | |||
TRANSACTION_QUANTITY | NUMBER | |||
TRANSACTION_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
SOURCE_DOC_QUANTITY | NUMBER | |||
SOURCE_DOC_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
PRIMARY_QUANTITY | NUMBER | |||
PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
INVENTORY_ITEM_ID | NUMBER | |||
PO_HEADER_ID | NUMBER | |||
PO_RELEASE_ID | NUMBER | |||
PO_LINE_ID | NUMBER | |||
PO_LINE_LOCATION_ID | NUMBER | |||
PO_DISTRIBUTION_ID | NUMBER | |||
INTERCOMPANY_PRICING_OPTION | NUMBER | |||
UNIT_PRICE | NUMBER | |||
TRANSACTION_AMOUNT | NUMBER | |||
PRIOR_UNIT_PRICE | NUMBER | |||
NR_TAX | NUMBER | |||
REC_TAX | NUMBER | |||
NR_TAX_AMOUNT | NUMBER | |||
REC_TAX_AMOUNT | NUMBER | |||
PRIOR_NR_TAX | NUMBER | |||
PRIOR_REC_TAX | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_DATE | DATE | |||
ACCOUNTED_FLAG | VARCHAR2 | (1) | ||
PROCUREMENT_ORG_FLAG | VARCHAR2 | (1) | ||
CROSS_OU_FLAG | VARCHAR2 | (1) | ||
TRX_FLOW_HEADER_ID | NUMBER | |||
INVOICED_FLAG | VARCHAR2 | (1) | ||
PA_ADDITION_FLAG | VARCHAR2 | (1) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (32) | ||
GL_GROUP_ID | NUMBER | |||
QUANTITY_RECEIVED | NUMBER | |||
QUANTITY_INVOICED | NUMBER | |||
AMOUNT_RECEIVED | NUMBER | |||
AMOUNT_INVOICED | NUMBER | |||
LCM_ACCOUNT_ID | NUMBER | |||
UNIT_LANDED_COST | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LCM_TRANSACTION_ID
, ACCOUNTING_EVENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, RCV_TRANSACTION_ID
, EVENT_TYPE_ID
, EVENT_SOURCE
, EVENT_SOURCE_ID
, SET_OF_BOOKS_ID
, ORG_ID
, TRANSFER_ORG_ID
, ORGANIZATION_ID
, TRANSFER_ORGANIZATION_ID
, DEBIT_ACCOUNT_ID
, CREDIT_ACCOUNT_ID
, DEBIT_ACCOUNTING_LINE_TYPE
, CREDIT_ACCOUNTING_LINE_TYPE
, TRANSACTION_DATE
, TRANSACTION_QUANTITY
, TRANSACTION_UNIT_OF_MEASURE
, SOURCE_DOC_QUANTITY
, SOURCE_DOC_UNIT_OF_MEASURE
, PRIMARY_QUANTITY
, PRIMARY_UNIT_OF_MEASURE
, INVENTORY_ITEM_ID
, PO_HEADER_ID
, PO_RELEASE_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID
, INTERCOMPANY_PRICING_OPTION
, UNIT_PRICE
, TRANSACTION_AMOUNT
, PRIOR_UNIT_PRICE
, NR_TAX
, REC_TAX
, NR_TAX_AMOUNT
, REC_TAX_AMOUNT
, PRIOR_NR_TAX
, PRIOR_REC_TAX
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, ACCOUNTED_FLAG
, PROCUREMENT_ORG_FLAG
, CROSS_OU_FLAG
, TRX_FLOW_HEADER_ID
, INVOICED_FLAG
, PA_ADDITION_FLAG
, USSGL_TRANSACTION_CODE
, GL_GROUP_ID
, QUANTITY_RECEIVED
, QUANTITY_INVOICED
, AMOUNT_RECEIVED
, AMOUNT_INVOICED
, LCM_ACCOUNT_ID
, UNIT_LANDED_COST
FROM BOM.CST_LC_RAE_EVENTS_GT;
BOM.CST_LC_RAE_EVENTS_GT does not reference any database object
BOM.CST_LC_RAE_EVENTS_GT is referenced by following:
|
|
|