DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FTE_PRC_VIEW_PRICE_UI_V

Object Details
Object Name: FTE_PRC_VIEW_PRICE_UI_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFTE.FTE_PRC_VIEW_PRICE_UI_V
Subobject Name:
Status: VALID

View Type

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


FTE_PRC_VIEW_PRICE_UI_V is used as the base view by the View Delivery Leg price ui


[View Source]

Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER

entity id
PARENT_ENTITY_ID NUMBER

parent entity id
DELIVERY_LEG_ID NUMBER

delivery leg id
ENTITY_NAME VARCHAR2 (4000)
entity name
ITEM_NAME VARCHAR2 (40)
item name
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

lasy updated by
LAST_UPDATE_LOGIN NUMBER

last update login
PROGRAM_APPLICATION_ID NUMBER

prgram 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
,      DELIVERY_LEG_ID
,      ENTITY_NAME
,      ITEM_NAME
,      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_VIEW_PRICE_UI_V;

Dependencies

[top of page]

APPS.FTE_PRC_VIEW_PRICE_UI_V references the following:

SchemaAPPS
PL/SQL PackageFTE_FREIGHT_PRICING_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWSH_DELIVERY_ASSIGNMENTS
SynonymWSH_DELIVERY_DETAILS
SynonymWSH_DELIVERY_LEGS
SynonymWSH_FREIGHT_COSTS
SynonymWSH_FREIGHT_COST_TYPES
SynonymWSH_NEW_DELIVERIES

APPS.FTE_PRC_VIEW_PRICE_UI_V is not referenced by any database object