[Home] [Help]
892: wdd.delivery_detail_id,
893: wdd.requested_quantity,
894: mtl.serial_number_control_code
895: FROM csd_repairs cr,
896: mtl_system_items_b mtl,
897: cs_estimate_details ced,
898: wsh_delivery_details wdd,
899: --Changed to view from table, bug: 4341784
900: wsh_delivery_assignments_v wda
1370: p.organization_code
1371: FROM wsh_delivery_details a,
1372: --Changed to view from table, bug: 4341784
1373: wsh_delivery_assignments_v b,
1374: mtl_system_items c,
1375: mtl_parameters p
1376: WHERE a.delivery_detail_id = b.delivery_detail_id
1377: AND a.inventory_item_id = c.inventory_item_id
1378: AND a.organization_id = c.organization_id
2374: l_orig_src_reference VARCHAR2(30);
2375: l_orig_src_header_id NUMBER;
2376: l_orig_src_line_id NUMBER;
2377: l_orig_po_num VARCHAR2(50);
2378: l_rev_ctl_code mtl_system_items.revision_qty_control_code%TYPE;
2379: l_booked_flag oe_order_headers_all.booked_flag%TYPE;
2380:
2381: --taklam
2382: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
3130:
3131: BEGIN
3132: SELECT revision_qty_control_code
3133: INTO l_rev_ctl_code
3134: FROM mtl_system_items
3135: WHERE organization_id =
3136: Cs_Std.get_item_valdn_orgzn_id
3137: AND inventory_item_id =
3138: x_product_txn_rec.inventory_item_id;
9254: THEN
9255: BEGIN
9256: SELECT Serial_Number_Control_COde
9257: INTO l_Serial_num_COntrol_Code
9258: FROM Mtl_System_Items_B
9259: WHERE Inventory_Item_Id = l_Inventory_Item_Id
9260: AND Organization_id = Cs_Std.Get_Item_Valdn_Orgzn_Id;
9261: -- If item is serial controlled then raise error
9262: IF l_Serial_num_COntrol_Code > 1
9273: WHEN NO_DATA_FOUND THEN
9274: -- Get Item Name
9275: SELECT items.concatenated_segments
9276: INTO l_Item_Name
9277: FROM mtl_system_items_vl items, csd_repairs dra
9278: WHERE dra.repair_line_id = p_Repair_Line_Id
9279: and dra.inventory_item_id = items.inventory_item_id
9280: and items.organization_id = cs_std.get_item_valdn_orgzn_id;
9281: