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 3408: FROM MTL_SYSTEM_ITEMS

3404: unit_weight,
3405: unit_volume,
3406: weight_uom_code,
3407: volume_uom_code
3408: FROM MTL_SYSTEM_ITEMS
3409: WHERE inventory_item_id = v_cont_item_id
3410: AND container_item_flag = 'Y'
3411: AND organization_id = v_org_id
3412: AND nvl(vehicle_item_flag,'N') = 'N';

Line 3415: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;

3411: AND organization_id = v_org_id
3412: AND nvl(vehicle_item_flag,'N') = 'N';
3413: --AND shippable_item_flag = 'Y';
3414:
3415: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;
3416: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3417: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3418: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3419: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;

Line 3416: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;

3412: AND nvl(vehicle_item_flag,'N') = 'N';
3413: --AND shippable_item_flag = 'Y';
3414:
3415: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;
3416: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3417: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3418: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3419: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3420: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;

Line 3417: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;

3413: --AND shippable_item_flag = 'Y';
3414:
3415: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;
3416: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3417: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3418: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3419: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3420: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3421: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;

Line 3418: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;

3414:
3415: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;
3416: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3417: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3418: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3419: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3420: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3421: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3422: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;

Line 3419: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;

3415: l_item_description MTL_SYSTEM_ITEMS.Description%TYPE;
3416: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3417: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3418: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3419: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3420: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3421: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3422: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
3423: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;

Line 3420: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;

3416: l_container_type_code MTL_SYSTEM_ITEMS.Container_Type_Code%TYPE;
3417: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3418: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3419: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3420: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3421: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3422: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
3423: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;
3424:

Line 3421: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;

3417: l_minimum_fill_percent MTL_SYSTEM_ITEMS.minimum_fill_percent%TYPE;
3418: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3419: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3420: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3421: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3422: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
3423: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;
3424:
3425: -- bug# 6719369 (replenishment project): begin

Line 3422: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;

3418: l_maximum_load_weight MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE;
3419: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3420: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3421: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3422: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
3423: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;
3424:
3425: -- bug# 6719369 (replenishment project): begin
3426: l_event VARCHAR2(600):= null;

Line 3423: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;

3419: l_maximum_volume MTL_SYSTEM_ITEMS.internal_volume%TYPE;
3420: l_unit_weight_item MTL_SYSTEM_ITEMS.unit_weight%TYPE;
3421: l_unit_volume_item MTL_SYSTEM_ITEMS.unit_volume%TYPE;
3422: l_weight_uom_code_item MTL_SYSTEM_ITEMS.weight_uom_code%TYPE;
3423: l_volume_uom_code_item MTL_SYSTEM_ITEMS.volume_uom_code%TYPE;
3424:
3425: -- bug# 6719369 (replenishment project): begin
3426: l_event VARCHAR2(600):= null;
3427: l_dd_released_status VARCHAR2(1);