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_INV dependencies on DUAL

Line 35: lot_control_code, tracking_quantity_ind, dual_uom_deviation_low,

31:
32: CURSOR c_item_info (v_organization_id NUMBER, v_inventory_item_id IN NUMBER) IS
33: SELECT organization_id, inventory_item_id,
34: primary_uom_code, secondary_uom_code, secondary_default_ind,
35: lot_control_code, tracking_quantity_ind, dual_uom_deviation_low,
36: dual_uom_deviation_high, enabled_flag, shippable_item_flag,
37: inventory_item_flag, lot_divisible_flag, container_item_flag,
38: reservable_type, mtl_transactions_enabled_flag, 'Y' valid_flag
39: FROM MTL_SYSTEM_ITEMS

Line 36: dual_uom_deviation_high, enabled_flag, shippable_item_flag,

32: CURSOR c_item_info (v_organization_id NUMBER, v_inventory_item_id IN NUMBER) IS
33: SELECT organization_id, inventory_item_id,
34: primary_uom_code, secondary_uom_code, secondary_default_ind,
35: lot_control_code, tracking_quantity_ind, dual_uom_deviation_low,
36: dual_uom_deviation_high, enabled_flag, shippable_item_flag,
37: inventory_item_flag, lot_divisible_flag, container_item_flag,
38: reservable_type, mtl_transactions_enabled_flag, 'Y' valid_flag
39: FROM MTL_SYSTEM_ITEMS
40: WHERE organization_id = v_organization_id

Line 1920: FROM dual;

1916:
1917: -- Bug 5028993: needs to pass transaction_temp_id
1918: CURSOR c_temp_id IS
1919: SELECT mtl_material_transactions_s.nextval
1920: FROM dual;
1921:
1922: l_inv_item_id NUMBER;
1923: l_org_id NUMBER;
1924: l_transaction_temp_id NUMBER;

Line 4963: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;

4959: end if;
4960: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
4961:
4962: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
4963: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
4965: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;

Line 4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;

4960: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
4961:
4962: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
4963: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
4964: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
4965: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
4966: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
4967: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
4968: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;

Line 4988: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);

4984: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
4985: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
4988: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
4989: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);

Line 4989: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);

4985: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
4986: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
4987: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
4988: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_low',x_mtl_system_items_rec.dual_uom_deviation_low);
4989: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.dual_uom_deviation_high',x_mtl_system_items_rec.dual_uom_deviation_high);
4990: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
4991: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
4992: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
4993: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);