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.

[Home] [Help]

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 2146: FROM dual;

2142:
2143: -- Bug 5028993: needs to pass transaction_temp_id
2144: CURSOR c_temp_id IS
2145: SELECT mtl_material_transactions_s.nextval
2146: FROM dual;
2147:
2148: l_inv_item_id NUMBER;
2149: l_org_id NUMBER;
2150: l_transaction_temp_id NUMBER;

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

5335: end if;
5336: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
5337:
5338: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
5339: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;

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

5336: x_mtl_system_items_rec.lot_control_code:=l_cache_rec.lot_control_code;
5337:
5338: x_mtl_system_items_rec.tracking_quantity_ind:=l_cache_rec.tracking_quantity_ind;
5339: x_mtl_system_items_rec.dual_uom_deviation_low:=l_cache_rec.dual_uom_deviation_low;
5340: x_mtl_system_items_rec.dual_uom_deviation_high:=l_cache_rec.dual_uom_deviation_high;
5341: x_mtl_system_items_rec.enabled_flag:=l_cache_rec.enabled_flag;
5342: x_mtl_system_items_rec.shippable_item_flag:=l_cache_rec.shippable_item_flag;
5343: x_mtl_system_items_rec.inventory_item_flag:=l_cache_rec.inventory_item_flag;
5344: x_mtl_system_items_rec.lot_divisible_flag:=l_cache_rec.lot_divisible_flag;

Line 5364: 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);

5360: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_uom_code',x_mtl_system_items_rec.secondary_uom_code);
5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: 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);
5365: 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);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);

Line 5365: 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);

5361: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.secondary_default_ind',x_mtl_system_items_rec.secondary_default_ind);
5362: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_control_code',x_mtl_system_items_rec.lot_control_code);
5363: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.tracking_quantity_ind',x_mtl_system_items_rec.tracking_quantity_ind);
5364: 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);
5365: 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);
5366: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.enabled_flag',x_mtl_system_items_rec.enabled_flag);
5367: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.shippable_item_flag',x_mtl_system_items_rec.shippable_item_flag);
5368: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.inventory_item_flag',x_mtl_system_items_rec.inventory_item_flag);
5369: WSH_DEBUG_SV.log(l_module_name,'x_mtl_system_items_rec.lot_divisible_flag',x_mtl_system_items_rec.lot_divisible_flag);