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.

APPS.WSH_DELIVERY_DETAILS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 3273: FROM MTL_SYSTEM_ITEMS

3269: unit_weight,
3270: unit_volume,
3271: weight_uom_code,
3272: volume_uom_code
3273: FROM MTL_SYSTEM_ITEMS
3274: WHERE inventory_item_id = v_cont_item_id
3275: AND container_item_flag = 'Y'
3276: AND organization_id = v_org_id
3277: AND nvl(vehicle_item_flag,'N') = 'N';

Line 3280: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;

3276: AND organization_id = v_org_id
3277: AND nvl(vehicle_item_flag,'N') = 'N';
3278: --AND shippable_item_flag = 'Y';
3279:
3280: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;
3281: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3282: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3283: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3284: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;

Line 3281: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;

3277: AND nvl(vehicle_item_flag,'N') = 'N';
3278: --AND shippable_item_flag = 'Y';
3279:
3280: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;
3281: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3282: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3283: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3284: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3285: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;

Line 3282: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;

3278: --AND shippable_item_flag = 'Y';
3279:
3280: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;
3281: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3282: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3283: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3284: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3285: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3286: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;

Line 3283: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;

3279:
3280: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;
3281: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3282: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3283: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3284: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3285: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3286: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3287: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;

Line 3284: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;

3280: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;
3281: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3282: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3283: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3284: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3285: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3286: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3287: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
3288: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;

Line 3285: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;

3281: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3282: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3283: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3284: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3285: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3286: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3287: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
3288: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;
3289:

Line 3286: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;

3282: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3283: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3284: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3285: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3286: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3287: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
3288: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;
3289:
3290: -- bug# 6719369 (replenishment project): begin

Line 3287: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;

3283: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3284: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3285: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3286: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3287: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
3288: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;
3289:
3290: -- bug# 6719369 (replenishment project): begin
3291: l_event VARCHAR2(600):= null;

Line 3288: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;

3284: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3285: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3286: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3287: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
3288: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;
3289:
3290: -- bug# 6719369 (replenishment project): begin
3291: l_event VARCHAR2(600):= null;
3292: l_dd_released_status VARCHAR2(1);