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

Object Details

Object Name:	QP_ATTRIBUTE_DEFNS_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
DURATION	NUMBER
USAGE_UOM	VARCHAR2	(240)
INVENTORY_ITEM_ID	VARCHAR2	(240)
ITEM_CATEGORY	VARCHAR2	(240)
ISTORE_SECTION	VARCHAR2	(240)
ALL_ITEMS	VARCHAR2	(240)
MULTIPIECE_FLAG	VARCHAR2	(240)
COMMODITY	NUMBER
LOADING_PROTOCOL	VARCHAR2	(240)
TL_CM_DISCOUNT_FLG	VARCHAR2	(240)
TL_DEADHEAD_RT_VAR	VARCHAR2	(240)
TL_DISTANCE_TYPE	VARCHAR2	(240)
TL_HANDLING_ACT	VARCHAR2	(240)
TL_NUM_WEEKEND_LAYOVERS	NUMBER
TL_RATE_BASIS	VARCHAR2	(240)
TL_RATE_TYPE	VARCHAR2	(240)
TL_SERVICE_TYPE	VARCHAR2	(240)
TL_STOP_LOADING_ACT	VARCHAR2	(240)
TL_STOP_UNLOADING_ACT	VARCHAR2	(240)
VEHICLE	NUMBER
CONTAINER_TYPE	VARCHAR2	(240)
SERVICE_TYPE	VARCHAR2	(240)
ORIGIN_ZONE	NUMBER
DESTINATION_ZONE	NUMBER
TOTAL_SHIPMENT_QUANTITY	NUMBER
NUMBER_OF_STUDENTS	NUMBER
CHARGE_PERIODICITY	VARCHAR2	(240)
SHIP_TO_ORG	VARCHAR2	(240)
SHIPMENT_HEADER_ID	VARCHAR2	(240)
SHIPMENT_LINE_ID	VARCHAR2	(240)
HAZARD_CLASS	VARCHAR2	(240)
HAZARD_CODE	VARCHAR2	(240)
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(240)
TO_ORGANIZATION_ID	VARCHAR2	(240)
PO_AGREEMENT_LINE_NUMBER	VARCHAR2	(240)
PO_AGREEMENT_NUM	VARCHAR2	(240)
ATTRIBUTE1	VARCHAR2	(240)
PARENT_LIST_PRICE	NUMBER
CUSTOMER_ITEM_ID	VARCHAR2	(240)
INSURANCE_COST	NUMBER
HANDLING_COST	NUMBER
EXPORT_COST	NUMBER
DUTY_COST	NUMBER
FREIGHT_COST	NUMBER
ADMINISTRATION_COST	NUMBER
MODEL_ID	VARCHAR2	(240)
FTEPRICE	NUMBER
FTECHARGE	NUMBER
LIST_LINE_ID	NUMBER
ASDQW	VARCHAR2	(240)
ITEM_QUANTITY	NUMBER
ITEM_AMOUNT	NUMBER
PERIOD1_ITEM_QUANTITY	NUMBER
TL_NUM_STOPS	NUMBER
TL_CHARGED_OUT_RT_DISTANCE	NUMBER
TL_NUM_WEEKDAY_LAYOVERS	NUMBER
TL_WEEKEND_LAYOVER_MILEAGE	NUMBER
TL_PICKUP_WT	NUMBER
TL_PICKUP_VOL	NUMBER
TL_PICKUP_CONTAINER	NUMBER
TL_PICKUP_PALLET	NUMBER
TL_DROPOFF_WT	NUMBER
PERIOD2_ITEM_QUANTITY	NUMBER
TL_DROPOFF_VOL	NUMBER
TL_DROPOFF_CONTAINER	NUMBER
TL_DROPOFF_PALLET	NUMBER
TL_HANDLING_WT	NUMBER
TL_HANDLING_VOL	NUMBER
FAC_PICKUP_WT	NUMBER
FAC_PICKUP_VOL	NUMBER
FAC_PICKUP_CONTAINER	NUMBER
FAC_PICKUP_PALLET	NUMBER
FAC_DROPOFF_WT	NUMBER
FAC_DROPOFF_VOL	NUMBER
PERIOD3_ITEM_QUANTITY	NUMBER
FAC_DROPOFF_CONTAINER	NUMBER
FAC_DROPOFF_PALLET	NUMBER
FAC_HANDLING_WT	NUMBER
FAC_HANDLING_VOL	NUMBER
FAC_HANDLING_CONTAINER	NUMBER
FAC_HANDLING_PALLET	NUMBER
PERIOD1_ITEM_AMOUNT	NUMBER
PERIOD2_ITEM_AMOUNT	NUMBER
PERIOD3_ITEM_AMOUNT	NUMBER
TOTAL_ITEM_QUANTITY	NUMBER
BLANKET_AMOUNT	NUMBER
GROUP_QUANTITY	NUMBER
GROUP_AMOUNT	NUMBER
BLANKET_LINE_AMOUNT	NUMBER
BLANKET_LINE_QUANTITY	NUMBER
PO_LINE_QUANTITY	NUMBER
PO_LINE_AMOUNT	NUMBER
TM_ACCUMULATED_VOLUME	NUMBER
CONCATENATED_SEGMENTS	VARCHAR2	(4000)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      DURATION
,      USAGE_UOM
,      INVENTORY_ITEM_ID
,      ITEM_CATEGORY
,      ISTORE_SECTION
,      ALL_ITEMS
,      MULTIPIECE_FLAG
,      COMMODITY
,      LOADING_PROTOCOL
,      TL_CM_DISCOUNT_FLG
,      TL_DEADHEAD_RT_VAR
,      TL_DISTANCE_TYPE
,      TL_HANDLING_ACT
,      TL_NUM_WEEKEND_LAYOVERS
,      TL_RATE_BASIS
,      TL_RATE_TYPE
,      TL_SERVICE_TYPE
,      TL_STOP_LOADING_ACT
,      TL_STOP_UNLOADING_ACT
,      VEHICLE
,      CONTAINER_TYPE
,      SERVICE_TYPE
,      ORIGIN_ZONE
,      DESTINATION_ZONE
,      TOTAL_SHIPMENT_QUANTITY
,      NUMBER_OF_STUDENTS
,      CHARGE_PERIODICITY
,      SHIP_TO_ORG
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      HAZARD_CLASS
,      HAZARD_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      TO_ORGANIZATION_ID
,      PO_AGREEMENT_LINE_NUMBER
,      PO_AGREEMENT_NUM
,      ATTRIBUTE1
,      PARENT_LIST_PRICE
,      CUSTOMER_ITEM_ID
,      INSURANCE_COST
,      HANDLING_COST
,      EXPORT_COST
,      DUTY_COST
,      FREIGHT_COST
,      ADMINISTRATION_COST
,      MODEL_ID
,      FTEPRICE
,      FTECHARGE
,      LIST_LINE_ID
,      ASDQW
,      ITEM_QUANTITY
,      ITEM_AMOUNT
,      PERIOD1_ITEM_QUANTITY
,      TL_NUM_STOPS
,      TL_CHARGED_OUT_RT_DISTANCE
,      TL_NUM_WEEKDAY_LAYOVERS
,      TL_WEEKEND_LAYOVER_MILEAGE
,      TL_PICKUP_WT
,      TL_PICKUP_VOL
,      TL_PICKUP_CONTAINER
,      TL_PICKUP_PALLET
,      TL_DROPOFF_WT
,      PERIOD2_ITEM_QUANTITY
,      TL_DROPOFF_VOL
,      TL_DROPOFF_CONTAINER
,      TL_DROPOFF_PALLET
,      TL_HANDLING_WT
,      TL_HANDLING_VOL
,      FAC_PICKUP_WT
,      FAC_PICKUP_VOL
,      FAC_PICKUP_CONTAINER
,      FAC_PICKUP_PALLET
,      FAC_DROPOFF_WT
,      FAC_DROPOFF_VOL
,      PERIOD3_ITEM_QUANTITY
,      FAC_DROPOFF_CONTAINER
,      FAC_DROPOFF_PALLET
,      FAC_HANDLING_WT
,      FAC_HANDLING_VOL
,      FAC_HANDLING_CONTAINER
,      FAC_HANDLING_PALLET
,      PERIOD1_ITEM_AMOUNT
,      PERIOD2_ITEM_AMOUNT
,      PERIOD3_ITEM_AMOUNT
,      TOTAL_ITEM_QUANTITY
,      BLANKET_AMOUNT
,      GROUP_QUANTITY
,      GROUP_AMOUNT
,      BLANKET_LINE_AMOUNT
,      BLANKET_LINE_QUANTITY
,      PO_LINE_QUANTITY
,      PO_LINE_AMOUNT
,      TM_ACCUMULATED_VOLUME
,      CONCATENATED_SEGMENTS
FROM APPS.QP_ATTRIBUTE_DEFNS_DFV;

Dependencies

[top of page]

APPS.QP_ATTRIBUTE_DEFNS_DFV references the following:

APPS: FND_NUMBER - show dependent code; QP_ATTRIBUTE_DEFNS

APPS.QP_ATTRIBUTE_DEFNS_DFV is not referenced by any database object