eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JMF.JMF_SHIKYU_SPR_RPT_TEMP

Object Details

Object Name:	JMF_SHIKYU_SPR_RPT_TEMP
Object Type:	TABLE
Owner:	JMF
FND Design Data:	JMF.JMF_SHIKYU_SPR_RPT_TEMP
Subobject Name:
Status:	VALID

Temporary Table Details

JMF.JMF_SHIKYU_SPR_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:
PCT Free:	10
PCT Used:	40

Primary Key: JMF_SHIKYU_SPR_RPT_TEMP_PK

SUBCONTRACT_PO_SHIPMENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
JMF_SHIKYU_SPR_RPT_TEMP_PK	NORMAL	UNIQUE		SUBCONTRACT_PO_SHIPMENT_ID

Columns

Name	Datatype	Length	Mandatory
SUBCONTRACT_PO_SHIPMENT_ID	NUMBER		Yes
SHIPMENT_TYPE	VARCHAR2	(25)
REPORT_TITLE_NUM	VARCHAR2	(60)
SUB_PO_NUM	VARCHAR2	(20)
AGENT_NAME	VARCHAR2	(240)
SUB_PO_LINE_NUM	NUMBER
SHIP_OR_RELEASE_NUM	VARCHAR2	(20)
REV_NUM	VARCHAR2	(20)
CREATION_DATE	DATE
CREATED_BY_NAME	VARCHAR2	(100)
REVISED_DATE	DATE
REVISED_BY_NAME	VARCHAR2	(100)
VENDOR_SITE_CODE	VARCHAR2	(15)
VENDOR_CITY_STATE_ZIP	VARCHAR2	(200)
VENDOR_COUNTRY	VARCHAR2	(30)
VENDOR_SITE_ADDRESS1	VARCHAR2	(240)
VENDOR_SITE_ADDRESS2	VARCHAR2	(240)
VENDOR_SITE_ADDRESS3	VARCHAR2	(240)
SHIP_TO_SITE_CODE	VARCHAR2	(60)
SHIP_TO_SITE_ADDRESS1	VARCHAR2	(240)
SHIP_TO_SITE_ADDRESS2	VARCHAR2	(240)
SHIP_TO_SITE_ADDRESS3	VARCHAR2	(240)
SHIP_TO_SITE_POSTAL_CODE	VARCHAR2	(30)
SHIP_TO_SITE_COUNTRY	VARCHAR2	(30)
BILL_TO_SITE_CODE	VARCHAR2	(60)
BILL_TO_SITE_ADDRESS1	VARCHAR2	(240)
BILL_TO_SITE_ADDRESS2	VARCHAR2	(240)
BILL_TO_SITE_ADDRESS3	VARCHAR2	(240)
BILL_TO_SITE_POSTAL_CODE	VARCHAR2	(30)
BILL_TO_SITE_COUNTRY	VARCHAR2	(30)
CUSTOMER_NUM	VARCHAR2	(25)
SUPPLIER_NUM	VARCHAR2	(30)
PAY_TERM	VARCHAR2	(50)
FREIGHT_TERM	VARCHAR2	(80)
FOB_TYPE	VARCHAR2	(80)
SHIPPING_CONTROL	VARCHAR2	(80)
SHIP_VIA	VARCHAR2	(25)
CONFIRM_TO_NAME	VARCHAR2	(50)
CONFIRM_TO_TELEPHONE	VARCHAR2	(15)
REQUESTER	VARCHAR2	(300)
NOTES	VARCHAR2	(480)
SHIPMENT_NUM	NUMBER
PROJECT_NUM	VARCHAR2	(25)
TASK_NUM	VARCHAR2	(25)
ITEM_NUM	VARCHAR2	(40)
ITEM_DESC	VARCHAR2	(240)
NEED_BY_DATE	DATE
PROMISED_DATE	DATE
QUANTITY	NUMBER
UOM	VARCHAR2	(25)
ITEM_PRICE	NUMBER
TAXABLE_FLAG	VARCHAR2	(20)
AMOUNT	NUMBER
AGENT_ID	NUMBER
VENDOR_ID	NUMBER
ITEM_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
COLUMN1	NUMBER
COLUMN2	NUMBER
COLUMN3	NUMBER
COLUMN4	NUMBER
COLUMN5	NUMBER
ATTRIBUTE1	VARCHAR2	(240)
ATTRIBUTE2	VARCHAR2	(240)
ATTRIBUTE3	VARCHAR2	(240)
ATTRIBUTE4	VARCHAR2	(240)
ATTRIBUTE5	VARCHAR2	(240)

Query Text

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


SELECT SUBCONTRACT_PO_SHIPMENT_ID
,      SHIPMENT_TYPE
,      REPORT_TITLE_NUM
,      SUB_PO_NUM
,      AGENT_NAME
,      SUB_PO_LINE_NUM
,      SHIP_OR_RELEASE_NUM
,      REV_NUM
,      CREATION_DATE
,      CREATED_BY_NAME
,      REVISED_DATE
,      REVISED_BY_NAME
,      VENDOR_SITE_CODE
,      VENDOR_CITY_STATE_ZIP
,      VENDOR_COUNTRY
,      VENDOR_SITE_ADDRESS1
,      VENDOR_SITE_ADDRESS2
,      VENDOR_SITE_ADDRESS3
,      SHIP_TO_SITE_CODE
,      SHIP_TO_SITE_ADDRESS1
,      SHIP_TO_SITE_ADDRESS2
,      SHIP_TO_SITE_ADDRESS3
,      SHIP_TO_SITE_POSTAL_CODE
,      SHIP_TO_SITE_COUNTRY
,      BILL_TO_SITE_CODE
,      BILL_TO_SITE_ADDRESS1
,      BILL_TO_SITE_ADDRESS2
,      BILL_TO_SITE_ADDRESS3
,      BILL_TO_SITE_POSTAL_CODE
,      BILL_TO_SITE_COUNTRY
,      CUSTOMER_NUM
,      SUPPLIER_NUM
,      PAY_TERM
,      FREIGHT_TERM
,      FOB_TYPE
,      SHIPPING_CONTROL
,      SHIP_VIA
,      CONFIRM_TO_NAME
,      CONFIRM_TO_TELEPHONE
,      REQUESTER
,      NOTES
,      SHIPMENT_NUM
,      PROJECT_NUM
,      TASK_NUM
,      ITEM_NUM
,      ITEM_DESC
,      NEED_BY_DATE
,      PROMISED_DATE
,      QUANTITY
,      UOM
,      ITEM_PRICE
,      TAXABLE_FLAG
,      AMOUNT
,      AGENT_ID
,      VENDOR_ID
,      ITEM_ID
,      CURRENCY_CODE
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      COLUMN5
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
FROM JMF.JMF_SHIKYU_SPR_RPT_TEMP;

Dependencies

[top of page]

JMF.JMF_SHIKYU_SPR_RPT_TEMP does not reference any database object

JMF.JMF_SHIKYU_SPR_RPT_TEMP is referenced by following:

APPS: JMF_SHIKYU_SPR_RPT_TEMP