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.FTE_PTRK_TOKENS_V

Object Details

Object Name:	FTE_PTRK_TOKENS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FTE.FTE_PTRK_TOKENS_V
Subobject Name:
Status:	VALID

View Type

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

Store all the tokens for tracking

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_LEG_ID	NUMBER		Yes	Delivery leg id
DESTINATION_POSTAL_CODE	VARCHAR2	(60)		Destination postal code
DESTINATION_CITY	VARCHAR2	(120)		Destination city
DESTINATION_STATE	VARCHAR2	(120)		Destination state
DESTINATION_COUNTRY_CODE	VARCHAR2	(120)		Destination country code
ORIGIN_POSTAL_CODE	VARCHAR2	(60)		Origin postal code
ORIGIN_CITY	VARCHAR2	(120)		Origin city
ORIGIN_STATE	VARCHAR2	(120)		Origin state
ORIGIN_COUNTRY_CODE	VARCHAR2	(120)		Origin country code
SHIP_FROM_DATE	VARCHAR2	(19)		Ship from date
SHIP_FROM_YEAR	VARCHAR2	(4)		Ship from year
SHIP_FROM_MONTH	VARCHAR2	(2)		Ship from month
SHIP_FROM_DAY	VARCHAR2	(2)		Ship from day
SHIP_TO_DATE	VARCHAR2	(19)		Ship to date
SHIP_TO_YEAR	VARCHAR2	(4)		Ship to year
SHIP_TO_MONTH	VARCHAR2	(2)		Ship to month
SHIP_TO_DAY	VARCHAR2	(2)		Ship to day

Query Text

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


SELECT DELIVERY_LEG_ID
,      DESTINATION_POSTAL_CODE
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_COUNTRY_CODE
,      ORIGIN_POSTAL_CODE
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_COUNTRY_CODE
,      SHIP_FROM_DATE
,      SHIP_FROM_YEAR
,      SHIP_FROM_MONTH
,      SHIP_FROM_DAY
,      SHIP_TO_DATE
,      SHIP_TO_YEAR
,      SHIP_TO_MONTH
,      SHIP_TO_DAY
FROM APPS.FTE_PTRK_TOKENS_V;

Dependencies

[top of page]

APPS.FTE_PTRK_TOKENS_V references the following:

APPS: WSH_DELIVERY_LEGS; WSH_LOCATIONS; WSH_TRIP_STOPS

APPS.FTE_PTRK_TOKENS_V is not referenced by any database object