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]

VIEW: APPS.ECE_POO_SHIPMENTS_V

Object Details

Object Name:	ECE_POO_SHIPMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EC.ECE_POO_SHIPMENTS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view extracts shipment information
for the outbound Purchase Order (850/ORDERS) transaction.

[View Source]

Columns

Name	Datatype	Length	Comments
SHIPMENT_NUMBER	NUMBER		Shipment Number
QUANTITY_ORIGINAL	NUMBER		Original Quantity
UOM_CODE	VARCHAR2	(0)	Unit of Measure Code
SHIPMENT_NEED_BY_DATE	DATE		Shipment Need By Date
SHIPMENT_PROMISED_DATE	DATE		Shipment Promised Date
SHIPMENT_LAST_ACCEPTABLE_DATE	DATE		Shipment Last Acceptable Date
QUANTITY_CANCELLED	NUMBER		Quantity Cancelled
QUANTITY_RECEIVED	NUMBER		Quantity Delivered
PRICE_OVERRIDE	NUMBER		Price Override
CANCELLED_FLAG	VARCHAR2	(1)	Cancelled Flag
CANCELLED_DATE	DATE		Cancelled Date
SHIP_VIA	VARCHAR2	(25)	Ship Via
FOB_CODE	VARCHAR2	(25)	FOB Code
FREIGHT_TERMS	VARCHAR2	(25)	Freight Terms
TAXABLE_FLAG	VARCHAR2	(1)	Taxable Flag
SHIPMENT_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Shipment Attribute Category
SHIPMENT_ATTRIBUTE1	VARCHAR2	(150)	Shipment Attribute 1
SHIPMENT_ATTRIBUTE2	VARCHAR2	(150)	Shipment Attribute 2
SHIPMENT_ATTRIBUTE3	VARCHAR2	(150)	Shipment Attribute 3
SHIPMENT_ATTRIBUTE4	VARCHAR2	(150)	Shipment Attribute 4
SHIPMENT_ATTRIBUTE5	VARCHAR2	(150)	Shipment Attribute 5
SHIPMENT_ATTRIBUTE6	VARCHAR2	(150)	Shipment Attribute 6
SHIPMENT_ATTRIBUTE7	VARCHAR2	(150)	Shipment Attribute 7
SHIPMENT_ATTRIBUTE8	VARCHAR2	(150)	Shipment Attribute 8
SHIPMENT_ATTRIBUTE9	VARCHAR2	(150)	Shipment Attribute 9
SHIPMENT_ATTRIBUTE10	VARCHAR2	(150)	Shipment Attribute 10
SHIPMENT_ATTRIBUTE11	VARCHAR2	(150)	Shipment Attribute 11
SHIPMENT_ATTRIBUTE12	VARCHAR2	(150)	Shipment Attribute 12
SHIPMENT_ATTRIBUTE13	VARCHAR2	(150)	Shipment Attribute 13
SHIPMENT_ATTRIBUTE14	VARCHAR2	(150)	Shipment Attribute 14
SHIPMENT_ATTRIBUTE15	VARCHAR2	(150)	Shipment Attribute 15
SHIP_TO_LOCATION_ID	NUMBER		Ship To Location ID
SHIP_TO_LOCATION_CODE	VARCHAR2	(60)	Ship To Location Code
SHIP_TO_CONTACT_LAST_NAME	VARCHAR2	(150)	Ship To Contact Last Name
SHIP_TO_CONTACT_FIRST_NAME	VARCHAR2	(150)	Ship To Contact First Name
SHIP_TO_ADDRESS_LINE_1	VARCHAR2	(240)	Ship To Address Line 1
SHIP_TO_ADDRESS_LINE_2	VARCHAR2	(240)	Ship To Address Line 2
SHIP_TO_ADDRESS_LINE_3	VARCHAR2	(240)	Ship To Address Line 3
SHIP_TO_CITY	VARCHAR2	(60)	Ship To City
SHIP_TO_POSTAL_CODE	VARCHAR2	(60)	Ship To Postal Code
SHIP_TO_COUNTRY	VARCHAR2	(60)	Ship To Country
SHIP_TO_REGION_1	VARCHAR2	(120)	Ship To Region 1
SHIP_TO_REGION_2	VARCHAR2	(120)	Ship To Region 2
SHIP_TO_REGION_3	VARCHAR2	(120)	Ship To Region 3
SHIP_TO_PHONE1	VARCHAR2	(60)	Ship To Phone 1
SHIP_TO_PHONE2	VARCHAR2	(60)	Ship To Phone 2
SHIP_TO_PHONE3	VARCHAR2	(60)	Ship To Phone 3
PO_HEADER_ID	NUMBER		Purchase Order Header ID
PO_LINE_ID	NUMBER		Purchase Order Line ID
POR_RELEASE_ID	NUMBER		Release ID
POR_RELEASE_NUM	NUMBER		Release Number
LINE_LOCATION_ID	NUMBER		Line Location ID
SHIP_TO_ORGANIZATION_NAME	VARCHAR2	(240)	Ship To Organization
SHIP_TO_EDI_LOCATION_CODE	VARCHAR2	(40)	Ship to EDI location code
START_DATE	DATE		START_DATE
END_DATE	DATE		END_DATE
CONSIGNED_FLAG	VARCHAR2	(1)	CONSIGNED_FLAG
SHIP_TO_SITE_NAME	VARCHAR2	(240)	SHIP_TO_SITE_NAME

Query Text

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


SELECT SHIPMENT_NUMBER
,      QUANTITY_ORIGINAL
,      UOM_CODE
,      SHIPMENT_NEED_BY_DATE
,      SHIPMENT_PROMISED_DATE
,      SHIPMENT_LAST_ACCEPTABLE_DATE
,      QUANTITY_CANCELLED
,      QUANTITY_RECEIVED
,      PRICE_OVERRIDE
,      CANCELLED_FLAG
,      CANCELLED_DATE
,      SHIP_VIA
,      FOB_CODE
,      FREIGHT_TERMS
,      TAXABLE_FLAG
,      SHIPMENT_ATTRIBUTE_CATEGORY
,      SHIPMENT_ATTRIBUTE1
,      SHIPMENT_ATTRIBUTE2
,      SHIPMENT_ATTRIBUTE3
,      SHIPMENT_ATTRIBUTE4
,      SHIPMENT_ATTRIBUTE5
,      SHIPMENT_ATTRIBUTE6
,      SHIPMENT_ATTRIBUTE7
,      SHIPMENT_ATTRIBUTE8
,      SHIPMENT_ATTRIBUTE9
,      SHIPMENT_ATTRIBUTE10
,      SHIPMENT_ATTRIBUTE11
,      SHIPMENT_ATTRIBUTE12
,      SHIPMENT_ATTRIBUTE13
,      SHIPMENT_ATTRIBUTE14
,      SHIPMENT_ATTRIBUTE15
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_CODE
,      SHIP_TO_CONTACT_LAST_NAME
,      SHIP_TO_CONTACT_FIRST_NAME
,      SHIP_TO_ADDRESS_LINE_1
,      SHIP_TO_ADDRESS_LINE_2
,      SHIP_TO_ADDRESS_LINE_3
,      SHIP_TO_CITY
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_COUNTRY
,      SHIP_TO_REGION_1
,      SHIP_TO_REGION_2
,      SHIP_TO_REGION_3
,      SHIP_TO_PHONE1
,      SHIP_TO_PHONE2
,      SHIP_TO_PHONE3
,      PO_HEADER_ID
,      PO_LINE_ID
,      POR_RELEASE_ID
,      POR_RELEASE_NUM
,      LINE_LOCATION_ID
,      SHIP_TO_ORGANIZATION_NAME
,      SHIP_TO_EDI_LOCATION_CODE
,      START_DATE
,      END_DATE
,      CONSIGNED_FLAG
,      SHIP_TO_SITE_NAME
FROM APPS.ECE_POO_SHIPMENTS_V;

Dependencies

[top of page]

APPS.ECE_POO_SHIPMENTS_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_LOCATIONS_ALL_TL; HZ_CUST_ACCOUNT_ROLES; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_RELATIONSHIPS; OE_DROP_SHIP_SOURCES; OE_ORDER_HEADERS_ALL; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PO_LINE_LOCATIONS

APPS.ECE_POO_SHIPMENTS_V is not referenced by any database object