[Home] [Help]
132: -- Getting the Primary UOM of the item
133: BEGIN
134: SELECT primary_uom_code
135: INTO l_primary_uom
136: FROM mtl_system_items_b
137: WHERE inventory_item_id = p_inventory_item_id
138: AND organization_id = NVL(p_ship_from_org_id,
139: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_org_id)); --4759251
140: EXCEPTION
903: BEGIN
904:
905: SELECT msi.lot_control_code
906: INTO l_lot_control_code
907: FROM mtl_system_items msi
908: WHERE msi.inventory_item_id = p_inventory_item_id
909: AND msi.organization_id = p_ship_from_org_id;
910:
911: IF l_lot_control_code = 2 THEN
1045: -- Getting the Primary UOM of the item
1046: BEGIN
1047: SELECT primary_uom_code
1048: INTO l_primary_uom
1049: FROM mtl_system_items_b
1050: WHERE inventory_item_id = p_inventory_item_id
1051: AND organization_id = NVL(p_ship_from_org_id,
1052: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_rsv_tbl(1).org_id)); --4759251
1053: EXCEPTION
2438: 'rset.reservation_set_name=:reservation_set_name';
2439:
2440: ELSE
2441: --Moac
2442: l_stmt := 'SELECT Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi ';
2443: --10241113
2444: IF p_selected_ids IS NOT NULL THEN
2445: l_stmt := 'SELECT l.Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi,oe_rsv_set_details rs ';
2446: END IF;
2441: --Moac
2442: l_stmt := 'SELECT Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi ';
2443: --10241113
2444: IF p_selected_ids IS NOT NULL THEN
2445: l_stmt := 'SELECT l.Line_id, l.org_id FROM OE_ORDER_LINES l, OE_ORDER_HEADERS_ALL h ,MTL_SYSTEM_ITEMS msi,oe_rsv_set_details rs ';
2446: END IF;
2447: l_stmt := l_stmt|| ' WHERE NVL(h.cancelled_flag,'||'''N'''||') <> ' ||'''Y'''||
2448: ' AND h.header_id = l.header_id'||
2449: ' AND h.open_flag = '||'''Y'''||