DBA Data[Home] [Help] [Dependency Information]

TABLE: JMF.JMF_SHIKYU_CUR_RPT_TEMP

Object Details
Object Name: JMF_SHIKYU_CUR_RPT_TEMP
Object Type: TABLE
Owner: JMF
FND Design Data: TableJMF.JMF_SHIKYU_CUR_RPT_TEMP
Subobject Name:
Status: VALID

Temporary Table Details

JMF.JMF_SHIKYU_CUR_RPT_TEMP 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$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
SOURCE VARCHAR2 (10)
INVENTORY_ORG_NAME VARCHAR2 (50)
PROJECT_NUM VARCHAR2 (50)
TASK_NUM VARCHAR2 (50)
VENDOR_NAME VARCHAR2 (50)
VENDOR_SITE_CODE VARCHAR2 (20)
ORDER_NUM VARCHAR2 (20)
LINE_NUM NUMBER

ITEM_ID NUMBER

ITEM_NAME VARCHAR2 (50)
ITEM_DESC VARCHAR2 (240)
UNIT_PRICE NUMBER

CURRENCY VARCHAR2 (15)
QUANTITY NUMBER

UOM_CODE VARCHAR2 (20)
UNIT_COST_FROZEN NUMBER

UNIT_COST_PLAN NUMBER

FUNC_UNIT_PRICE VARCHAR2 (20)
PRIMARY_QTY NUMBER

FUNC_CURRENCY_CODE VARCHAR2 (20)
ORDER_LINE_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SOURCE
,      INVENTORY_ORG_NAME
,      PROJECT_NUM
,      TASK_NUM
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      ORDER_NUM
,      LINE_NUM
,      ITEM_ID
,      ITEM_NAME
,      ITEM_DESC
,      UNIT_PRICE
,      CURRENCY
,      QUANTITY
,      UOM_CODE
,      UNIT_COST_FROZEN
,      UNIT_COST_PLAN
,      FUNC_UNIT_PRICE
,      PRIMARY_QTY
,      FUNC_CURRENCY_CODE
,      ORDER_LINE_ID
FROM JMF.JMF_SHIKYU_CUR_RPT_TEMP;

Dependencies

[top of page]

JMF.JMF_SHIKYU_CUR_RPT_TEMP does not reference any database object

JMF.JMF_SHIKYU_CUR_RPT_TEMP is referenced by following:

SchemaAPPS
SynonymJMF_SHIKYU_CUR_RPT_TEMP