[Home] [Help] [Dependency Information]
Object Name: | QP_ATTRIBUTE_DEFNS_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
APPS.QP_ATTRIBUTE_DEFNS_DFV is not referenced by any database object
|
|
|