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_PRC_LANE_COMP_UI_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

FTE_PRC_LANE_COMP_UI_V is the base view for the lane price comparison user interface

[View Source]

Columns

Name	Datatype	Length	Comments
ENTITY_ID	VARCHAR2	(71)	entity id
PARENT_ENTITY_ID	VARCHAR2	(71)	parent entity id
LANE_SCHED_ID	VARCHAR2	(71)	lane or schedule id
COMPARISON_REQUEST_ID	NUMBER		comparison request id
DELIVERY_ID	NUMBER		delivery id
LANE_ID	NUMBER		lane_id
SCHEDULE_ID	NUMBER		schedule id
ENTITY_NAME	VARCHAR2	(4000)	entity name
ITEM_NAME	VARCHAR2	(40)	item name
SERVICE_TYPE	VARCHAR2	(4000)	Service Type
CONTAINER_TYPE	VARCHAR2	(4000)	container type
WEIGHT	VARCHAR2	(44)	weight
VOLUME	VARCHAR2	(44)	volume
PRICE	VARCHAR2	(56)	price
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
PROGRAM_APPLICATION_ID	NUMBER		program application id
PROGRAM_ID	NUMBER		program id
PROGRAM_UPDATE_DATE	DATE		program update date
REQUEST_ID	NUMBER		request id

Query Text

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


SELECT ENTITY_ID
,      PARENT_ENTITY_ID
,      LANE_SCHED_ID
,      COMPARISON_REQUEST_ID
,      DELIVERY_ID
,      LANE_ID
,      SCHEDULE_ID
,      ENTITY_NAME
,      ITEM_NAME
,      SERVICE_TYPE
,      CONTAINER_TYPE
,      WEIGHT
,      VOLUME
,      PRICE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM APPS.FTE_PRC_LANE_COMP_UI_V;

Dependencies

[top of page]

APPS.FTE_PRC_LANE_COMP_UI_V references the following:

APPS: FTE_FREIGHT_COSTS_TEMP; FTE_FREIGHT_PRICING_UTIL - show dependent code; FTE_LANES; MTL_SYSTEM_ITEMS_KFV; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_FREIGHT_COST_TYPES

APPS.FTE_PRC_LANE_COMP_UI_V is not referenced by any database object