[Home] [Help] [Dependency Information]
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 |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JMF_SHIKYU_SPR_RPT_TEMP_PK | NORMAL | UNIQUE | SUBCONTRACT_PO_SHIPMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
JMF.JMF_SHIKYU_SPR_RPT_TEMP does not reference any database object
JMF.JMF_SHIKYU_SPR_RPT_TEMP is referenced by following:
|
|
|