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: EC.ECE_SPSO_SHIP_DET

Object Details

Object Name:	ECE_SPSO_SHIP_DET
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_SPSO_SHIP_DET
Subobject Name:
Status:	VALID

ECE_SPSO_SHIP_DET

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_SPSO_SHIP_DET_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SCHEDULE_ID SCHEDULE_ITEM_ID SCHEDULE_ITEM_DETAIL_SEQUENCE

Columns

Name	Datatype	Length	Mandatory	Comments
RUN_ID	NUMBER		Yes	RUN_ID
SCHEDULE_SHIP_ID	NUMBER		Yes	SCHEDULE_SHIP_ID
SCHEDULE_ID	NUMBER		Yes	schedule_id
SCHEDULE_ITEM_ID	NUMBER		Yes	schedule_item_id
SCHEDULE_ITEM_DETAIL_SEQUENCE	NUMBER		Yes	schedule_item_detail_sequence
ITEM_DET_SHIP_QUANTITY	NUMBER			item_det_ship_quantity
ITEM_DET_UOM_CODE	VARCHAR2	(20)		item_det_uom_code
ITEM_DET_ST_LOC_CODE	VARCHAR2	(60)		item_det_st_loc_code
ITEM_DET_ST_LOC_CODE_EXT	VARCHAR2	(60)		Item_det_st_loc_code_ext
ITEM_DET_ST_ADDR_1	VARCHAR2	(240)		Item_det_st_addr_1
ITEM_DET_ST_ADDR_2	VARCHAR2	(240)		Item_det_st_addr_2
ITEM_DET_ST_ADDR_3	VARCHAR2	(240)		Item_det_st_addr_3
ITEM_DET_ST_CITY	VARCHAR2	(30)		Item_det_st_city
ITEM_DET_ST_POSTAL_CODE	VARCHAR2	(30)		Item_det_st_postal_code
ITEM_DET_ST_COUNTRY	VARCHAR2	(60)		Item_det_st_country
ITEM_DET_ST_REGION_1	VARCHAR2	(120)		Item_det_st_region_1
ITEM_DET_ST_REGION_2	VARCHAR2	(120)		Item_det_st_region_2
ITEM_DET_ST_REGION_3	VARCHAR2	(120)		Item_det_st_region_3
ITEM_DET_ST_PHONE	VARCHAR2	(60)		Item_det_st_phone
TRANSACTION_RECORD_ID	NUMBER			Transaction_record_id
DOCUMENT_RELEASE_NUMBER	VARCHAR2	(240)		Document_release_number
DOCUMENT_LINE_NUMBER	NUMBER			Document_line_number
DOCUMENT_SHIPMENT_NUMBER	NUMBER			Document_shipment_number
ITEM_DET_UOM_CODE_EXT1	VARCHAR2	(80)		Item_det_uom_code_ext1
ITEM_DET_UOM_CODE_EXT2	VARCHAR2	(80)		Item_det_uom_code_ext2
ITEM_DET_UOM_CODE_EXT3	VARCHAR2	(80)		Item_det_uom_code_ext3
ITEM_DET_UOM_CODE_EXT4	VARCHAR2	(80)		Item_det_uom_code_ext4
ITEM_DET_UOM_CODE_EXT5	VARCHAR2	(80)		Item_det_uom_code_ext5
ITEM_DET_ST_COUNTRY_EXT	VARCHAR2	(60)		Item_det_st_country_ext
ITEM_DET_ST_REGION_1_EXT	VARCHAR2	(120)		Item_det_st_region_1_ext
ITEM_DET_ST_REGION_2_EXT	VARCHAR2	(120)		Item_det_st_region_2_ext
ITEM_DET_ST_REGION_3_EXT	VARCHAR2	(120)		Item_det_st_region_3_ext
CREATION_DATE	DATE			Creation_date
CREATED_BY	NUMBER			Created_by
LAST_UPDATE_DATE	DATE			Last_update_date
LAST_UPDATED_BY	NUMBER			Last_updated_by
LAST_UPDATE_LOGIN	NUMBER			Last_update_login
REQUEST_ID	NUMBER			Request_id
PROGRAM_APPLICATION_ID	NUMBER			Program_application_id
PROGRAM_ID	NUMBER			Program_id
PROGRAM_UPDATE_DATE	DATE			Program_update_date
LINE_LOCATION_ID	NUMBER			LINE_LOCATION_ID

Query Text

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


SELECT RUN_ID
,      SCHEDULE_SHIP_ID
,      SCHEDULE_ID
,      SCHEDULE_ITEM_ID
,      SCHEDULE_ITEM_DETAIL_SEQUENCE
,      ITEM_DET_SHIP_QUANTITY
,      ITEM_DET_UOM_CODE
,      ITEM_DET_ST_LOC_CODE
,      ITEM_DET_ST_LOC_CODE_EXT
,      ITEM_DET_ST_ADDR_1
,      ITEM_DET_ST_ADDR_2
,      ITEM_DET_ST_ADDR_3
,      ITEM_DET_ST_CITY
,      ITEM_DET_ST_POSTAL_CODE
,      ITEM_DET_ST_COUNTRY
,      ITEM_DET_ST_REGION_1
,      ITEM_DET_ST_REGION_2
,      ITEM_DET_ST_REGION_3
,      ITEM_DET_ST_PHONE
,      TRANSACTION_RECORD_ID
,      DOCUMENT_RELEASE_NUMBER
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_SHIPMENT_NUMBER
,      ITEM_DET_UOM_CODE_EXT1
,      ITEM_DET_UOM_CODE_EXT2
,      ITEM_DET_UOM_CODE_EXT3
,      ITEM_DET_UOM_CODE_EXT4
,      ITEM_DET_UOM_CODE_EXT5
,      ITEM_DET_ST_COUNTRY_EXT
,      ITEM_DET_ST_REGION_1_EXT
,      ITEM_DET_ST_REGION_2_EXT
,      ITEM_DET_ST_REGION_3_EXT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LINE_LOCATION_ID
FROM EC.ECE_SPSO_SHIP_DET;

Dependencies

[top of page]

EC.ECE_SPSO_SHIP_DET does not reference any database object

EC.ECE_SPSO_SHIP_DET is referenced by following:

APPS: ECE_SPSO_SHIP_DET